EXCEL Transistor Sheet

Digital tools for electronic work: software for pcb design, schematic drawing, circuit simulation, parts inventory tools, ...
Post Reply
User avatar
chicago_mike
Tube Twister
Information
Posts: 1754
Joined: 03 Jul 2008, 04:38
Has thanked: 22 times
Been thanked: 316 times

Post by chicago_mike »

The origional is a MS Works file. We use this for parts substitutions and such.

I used a JAVA Web applet to convert to Excel. Its not perfect, but I think anybody here could fix it.

The idea with the sheet is say you need a transistor..you can search the part, and find specs...then use the search function to match it to hfe, volts, current, and such. Like a crossover sheet, but one thats "active".

I have included the origional works file as well as excel.

perhaps we can keep this updated as well. We still use this at work and update it there too.
Attachments
Bipolar2011.zip
(490.8 KiB) Downloaded 336 times
Skyline FX 2013

User avatar
.Mike
Solder Soldier
Information
Posts: 167
Joined: 18 Aug 2008, 06:21
Location: Savannah, GA
Has thanked: 2 times
Been thanked: 31 times
Contact:

Post by .Mike »

Cool idea.

You should put all of the headings on one line, and then do Data -> Filter -> Autofilter.

That allows you to search and sort very easily, setting up multiple criteria and viewing the results in a non-destructive fashion.

:)

Mike
My website: America's Debate | My effects site: Just one more build...

User avatar
chicago_mike
Tube Twister
Information
Posts: 1754
Joined: 03 Jul 2008, 04:38
Has thanked: 22 times
Been thanked: 316 times

Post by chicago_mike »

Thats the thing..

In Works thats kinda how its laid out. So you can search super easy. But all that got messed up in the java applet converter.

I think I can save the origional in something excel can easily open up, but not till Friday.

Unless someone else still has works for windows.. :lol:
Skyline FX 2013

Post Reply