Excel spreadsheet finds ALL possible series and parallel resistor solutions

[deepNcrispy]

Thanks FdW!

found excel format online, gives Ω, KΩ & M Ω. syntax as per:

[<1000]##.##Ω;[<1000000]##.##KΩ;##.##,,\MΩ

not dared try to integrate it into your sheet tho.

hope that helps someone out there!

:-j

 

[FdW]

Thanks for the format hint, as it is more involved than a few minutes I have to postpone implementing for now. But a note has been put in place.

 

[deepNcrispy]

Ah! Was not expecting that!! Fingers crossed it is easy to add.


The formatting made the numbers jump off the page for me, i'm likely to err in the 10,000Ω to 100,000Ω area when dealing with naked ohms!

Without this becoming Dev request central as the existing XLS is enough of a labour saver as is...

A formatting highlight to flag when a single R will fit popped into my head. (at the moment i can search for 0.00Ω) ah. search no worky. eyeball search it is!


Prior to finding your sheet i was looing at eg 120Ω 10% upper = 132Ω, lower = 108Ω

&

(EX)work had implemented a C++(?) version that gave values for 3 way resistor networks (epic!) but they did not have a full E96 set!! D'Oh! (but it did know the values allegedly stocked on MRP in stores)

Which inspired the idea of: "I have run out of these resistor values" column as a cross reference for me to check on. hmmm.

*******

where to put the pile of collated R's? ?? resistor book sets = mega bucks so wondering about A4 ring-binder business card holders:

https://api.durable.de/media/thumb/.../visitenkartenhuellen-din-a4-2389-durable.jpg

(no affiliation; just needed a linked picture!) mebe a wrap of 20 in each holder?

also looked at the A4 pocket sheets for camera negatives / slides but the best shapes had the wrong angle openings.

blast!

(not expecting the binder to survive being shook; needs careful handling)

any thoughts welcome

:-j

 

[wgh52]

@FdW:

Thanks a million for creating and providing this useful calaculation tool!

Works perfectly and is really useful for me in some precision applications or when I've run out of a specific value

Greetings,
Winfried

 

[FdW]

...
any thoughts welcome

:-j

What about this, a drawer with plastic sealed bags

Somewhere here there is a thread showing how I did build the cabinet.

Frans.

 

[deepNcrispy]

Definitely a contender!

referenced resource:
How do you store your Resistors and small Capacitors?

thanks for pointer; nice build & that is where I should have posted the Question!

Cheers!

:-j

 

[Sharkythefrog]

Downloaded and added a value. I think I get some strange result (or do not understand it). See enclosed picture.

 

[avtech]

Yours seems to be several decimal places out for some reason. Perhaps some default setting you have?

 

[deepNcrispy]

Hi Sharky,
Ran your figure (attached) the differences I can see are the comma instead of decimal
& 'SANT'. Which version of what spread sheet software are you running?

:-j

 

[avtech]

That's most likely from default language settings in excel / windows.

 

[deepNcrispy]

it looks like the xls is seeing your:

30.0 as 3.0

and displaying resistor values as divided by 1000

(I get a near identical table by entering 3 ohms
if I enter 0.3 or under; it rounds to zero & returns a blank table)