Performance Series DIY

[skeptical1]

Awesome matrix!!!
Thanks

[JBLnsince1959]

Earl K:

great!!! thanks for the lesson, I almost understand it ( no seriously that helped a lot). thanks again. this just shows i'm going to have to get an electronics 101 book and start learning this stuff.

Giskard..amazing matrix, really cool..I can't believe it's all there...Now, how do I use it?

also, if you delete THAT post it's

[JBLnsince1959]

The answer is likely which specific values of caps are available from the parts' suppliers .

(i) Net capacitance ( of series caps ) = the reciprocal sum of all the caps in the series .

(ii) An example ; 100 uf & 130 uf in series = 56.52 uF ( effective capacitance )

> 100 ( its' reciprocal = .010000000 )
> 130 ( its' reciprocal = .007692308 )
> Sum = ( .017692308 )
> Reciprocal of ( .017692308 ) = 56.52173913

- Obviously; 2 , 112uF caps in series will give a capacitance of 56 uF .

(iii) Another example ;

> 112 ( its' reciprocal = .008928571 )
> 3 of these identical caps in series = .008928571 x 3 , giving a new total of .026785714
> Reciprocal of ( .026785714 ) = 37.3333333

> So, 3 , 112uF caps in series will give a net capacitance of 37.33 uF .

Ok, I'm running some numbers here and examples and I think I've got this understood....thanks...way cool...

now back to the matrix and see if I can figure that out ( I really should be working)

re did some number here's and I see it more exactly ( shouldn't be doing this when I'm working

[Uncle Paul]

Exactly.

Everyone should have their biased capacitor matrix at the ready.

And here is how to quickly make your own:

1) Place the values for the capacitors (or inductors) in Row 1 and Column A as below.
3) Enter =1/((1/B$1) + (1/$A2)) in Row 2 Column 2 (R2C2)
4) Copy R2C2 to all the cells enclosed within the values you entered in step 1
5) Excel automagically adjust rows and columns in the formula and fills in all the blanks. Format the cells to a number so you can set the desired number of decimal places.

Note that series capacitors (Edit) and parallel inductors are calculated the same way. Usually for an inductor you can unwind the next larger value to the desired size.

[Earl K]

Note that series resistors and parallel inductors are calculated the same way. Usually for an inductor you can unwind the next larger value to the desired size.

- Nooo,,,,,

(i) That should read , ,,,,"Note that parallel resistors & parallel inductors are calculated the same way".

(ii) The values of "Series Resistors" are added directly to obtain the new working value . As is ; inductors that are in series, ( the inductances are added directly ) . Capacitors that are in parallel are added directly to get the new working capacitance .

[Uncle Paul]

- Nooo,,,,,

(i) That should read , ,,,,"Note that parallel resistors & parallel inductors are calculated the same way".

(ii) The values of "Series Resistors" are added directly to obtain the new working value . As is ; inductors that are in series, ( the inductances are added directly ) . Capacitors that are in parallel are added directly to get the new working capacitance .

I was thinking capacitors, but my fingers typed resistor.
Thanks for catching it - post edited.