EXCEL Transistor Sheet

Digital tools for electronic work: software for pcb design, schematic drawing, circuit simulation, parts inventory tools, ...

EXCEL Transistor Sheet

Postby chicago_mike » 27 Jun 2012, 19:44

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.
You do not have the required permissions to view the files attached to this post.
Skyline FX 2013

For this message the author chicago_mike has received thanks: 4
Belanger88 (27 Jun 2017, 16:47), dorrisant (19 Sep 2012, 19:21), Ihunda (27 Jun 2012, 19:48), rocklander (27 Jun 2012, 22:22)
User avatar
chicago_mike
Tube Twister
 
Posts: 1760
Joined: 03 Jul 2008, 05:38
Has thanked: 23 times
Have thanks: 303 times

Re: EXCEL Transistor Sheet

Postby .Mike » 27 Jun 2012, 19:49

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
.Mike
Solder Soldier
 
Posts: 173
Joined: 18 Aug 2008, 07:21
Location: Savannah, GA
Has thanked: 2 times
Have thanks: 32 times

Re: EXCEL Transistor Sheet

Postby chicago_mike » 27 Jun 2012, 19:57

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
User avatar
chicago_mike
Tube Twister
 
Posts: 1760
Joined: 03 Jul 2008, 05:38
Has thanked: 23 times
Have thanks: 303 times


Return to Software Room

Who is online

Users browsing this forum: No registered users and 1 guest