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
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
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.
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
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
@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
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
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
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
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)
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)
- Home
- Design & Build
- Software Tools
- Excel spreadsheet finds ALL possible series and parallel resistor solutions