开云体育

?

As I have learned so many times the hard way, there are several apps on the web that do this automatically.

?

One I found to be particularly helpful is this one that will calculate to any precision you desire down to 1% with any values you might find in your junk drawer and it tells you the deviation from your desired percentage and which of the values will give the closest match.

?

?

Dennis

?

From: TekScopes@... [mailto:TekScopes@...] On Behalf Of Reed Dickinson
Sent: Monday, March 11, 2013 12:58 PM
To: TekScopes@...
Subject: [TekScopes] Parallel resistance spreadsheet

?

Nothing works, back to the drawing bored!

On 3/11/2013 12:54 PM, Reed Dickinson wrote:

?

Well gang, may be the third time will bear fruit.? I shortened the file name.? If this does not work then save the files PAR.* in a folder and open with your spreadsheet program.? I did not test it in Access but it works in Lotus.

Reed

On 3/11/2013 12:48 PM, Reed Dickinson wrote:

?

I just tried to read the file PARALLEL.WK1 that came back form Tekscopes and it was corrupted.? I will re-attach another copy.? Lets see how this one works.

On 3/11/2013 12:28 PM, Reed Dickinson wrote:

?

There was a thread a few weeks ago about a parallel resistance
calculator. I created a spreadsheet that allows you to instantly select
a pair of 5% resistors to yield just about any resistance value
desired. I used the @VLOOKUP function in Lotus 123 and every value of
5% resistor from 10 Ohms up to 36MOhms is included. I will attach a
copy to this note. Please reply if any improvements can be incorporated.

Reed Dickinson
reed714@...

?

?