Forums :: Resources :: Features :: Photo Gallery :: Vintage Radio Shows :: Archives :: Books
Support This Site: Contributors :: Advertise


It is currently Dec Sat 16, 2017 9:46 pm


All times are UTC [ DST ]





Post New Topic Post Reply  [ 18 posts ] 
Author Message
 Post subject: Excel file for managing tubes
PostPosted: Dec Mon 19, 2016 7:11 am 
Member

Joined: Oct Thu 02, 2014 5:57 am
Posts: 506
Location: Memphis, TN
Does anyone have an excel file/template that they could post for people to use to help manage tubes? I used the search feature and it seems some people have one, but I couldn't find the template.

Essentially, I'd like to find a way to list a bunch of radios and their tubes, then have excel sort unique tubes and then count duplicates. I'd think a tube caddy could just be subbed in for a radio, so it could be used to track everything someone has. With this, I could see how many radios I've got use a 6K7G for example. Obviously it's easy with only a couple of radios and one tube caddy, but who stops collecting there? :lol:


Top
 Profile  
 
 Post subject: Re: Excel file for managing tubes
PostPosted: Dec Mon 19, 2016 7:56 am 
Member
User avatar

Joined: Apr Sun 01, 2012 9:55 pm
Posts: 8141
Location: Seattle area, WA
I know some Excel experts. But be careful what you ask for... :wink:
https://m.youtube.com/watch?v=BKorP55Aqvg

Seriously though, I've attempted some aggregation like you propose, and I haven't succeeded. It's not easy in Excel, maybe not even possible, although I'd love someone to contradict me. The fundamental truth is, Excel is not a database.


Top
 Profile  
 
 Post subject: Re: Excel file for managing tubes
PostPosted: Dec Mon 19, 2016 12:27 pm 
Member
User avatar

Joined: Jan Mon 18, 2010 2:13 am
Posts: 15384
Location: Dayton Ohio
Rodney is correct, Excel is not a very good database. It is setup by default to manipulate numbers and change things you don't want changed.
It likes to "think for you" and change things around.

MS Access or Libre Office Base would be a better choice, and I'm sure there is a template available somewhere.

There were a couple of radio inventory software apps out there, but I'm having difficulty finding them. I think this is one of them but I cannot access the website at work.
http://hanksradioland.altervista.org/htm/sharware.htm

-Steve

_________________
Radio Interests
-Zenith
-Sparton
-Pre-War FM
Consoles and floor models, the bigger, the better!


Top
 Profile  
 
 Post subject: Re: Excel file for managing tubes
PostPosted: Dec Tue 20, 2016 12:22 am 
Member

Joined: Oct Thu 02, 2014 5:57 am
Posts: 506
Location: Memphis, TN
Thanks guys! Now I don't feel like such an idiot for not being able to get excel to do what I wanted... :wink: I'm guessing most people just do manual inventory? Basically meaning the quickest way to find a tube in your stash is to order one since you think you're out?


Top
 Profile  
 
 Post subject: Re: Excel file for managing tubes
PostPosted: Dec Tue 20, 2016 12:46 am 
Member

Joined: Jan Thu 01, 1970 1:00 am
Posts: 7339
Location: Minneapolis, MN USA
Here is a screen shot of my Filemaker based tube database. It tracks what I own, what I have used, it has basing info and general electrical parameters for quick glance. My collection is tucked away under the work benches which makes it hard to rummage thru to know what I own. Thus the existance of the database.


Image


Top
 Profile  
 
 Post subject: Re: Excel file for managing tubes
PostPosted: Dec Tue 20, 2016 1:01 am 
Member
User avatar

Joined: Jul Mon 06, 2015 11:25 am
Posts: 170
You might look at this free electronic component organizer software to see if it could work for your purposes:
http://www.jameco.com/Jameco/workshop/MyStory/WinHeist.html.

I just downloaded and installed it, but haven't had time to evaluate it.


Top
 Profile  
 
 Post subject: Re: Excel file for managing tubes
PostPosted: Dec Tue 20, 2016 2:47 am 
Member
User avatar

Joined: Mar Tue 04, 2014 3:29 am
Posts: 1994
Location: Long Beach, CA 90808
That looks nice Dale!

What version of Filemaker is it?

Did you make it from scratch or use an existing database as a template?

_________________
Aloha, Ken

No Console Left Behind!
Come join us @ http://vintagehifi.net/


Top
 Profile  
 
 Post subject: Re: Excel file for managing tubes
PostPosted: Dec Tue 20, 2016 4:55 am 
Member

Joined: Jan Thu 01, 1970 1:00 am
Posts: 7339
Location: Minneapolis, MN USA
Filemaker v11 from scratch. Lots of determination and time.


Top
 Profile  
 
 Post subject: Re: Excel file for managing tubes
PostPosted: Dec Tue 20, 2016 5:42 am 
Member

Joined: Jan Thu 01, 1970 1:00 am
Posts: 3038
Location: Massachusetts
no easy way to sort tube types, as I tried doing a tube inventory database years ago and ran into this problem. Forget how I resolved it, but you just can't tell Excel or a Database to sort by the tube number, I may have created another column, and padded the tube numbers with spaces before the actual tube number, so it sorted in a better order.

Another way to sort them could be a column the would have filament voltage, and sort by that, then the tube number.


Top
 Profile  
 
 Post subject: Re: Excel file for managing tubes
PostPosted: Dec Tue 20, 2016 10:55 pm 
Member

Joined: Oct Thu 02, 2014 5:57 am
Posts: 506
Location: Memphis, TN
Well, I couldn't get either of those programs to work properly... WinHeist looks great, but it keeps saying it doesn't have permission to access the Program Files folder. The other one worked well for a while, but then it randomly cleared out all of the radios/tubes I'd added...

Maybe a note pad and pen are in my future. :|


Top
 Profile  
 
 Post subject: Re: Excel file for managing tubes
PostPosted: Dec Wed 21, 2016 12:03 am 
Member

Joined: Jan Thu 01, 1970 1:00 am
Posts: 7339
Location: Minneapolis, MN USA
Displaying tube names in a sensible manner does take effort. But it is doable.
I like my sort results to show tube names by count of characters not including the envelope style.
So 80 comes before 6a8 which comes before 12SK7, etc.

I solved it by using one field for tube name and another field for name type.
Sort by name type not by tube name.

Digits only would be tubes 45, 80 etc
1Num1Letter would be 6a8, 6L6, etc
2Num2Letter would be 6SA7, 1LC6 etc

Image


Top
 Profile  
 
 Post subject: Re: Excel file for managing tubes
PostPosted: Dec Sun 25, 2016 7:15 am 
Member

Joined: Aug Fri 28, 2015 9:26 am
Posts: 794
Location: Fort Mohave Arizona 86426
Dale Saukerson wrote:
Here is a screen shot of my Filemaker based tube database. It tracks what I own, what I have used, it has basing info and general electrical parameters for quick glance. My collection is tucked away under the work benches which makes it hard to rummage thru to know what I own. Thus the existance of the database.


Image


Hey Dale, looks great. You ought to make a template and sell it. I would definitely buy one.


Top
 Profile  
 
 Post subject: Re: Excel file for managing tubes - don't
PostPosted: Jan Sat 07, 2017 6:29 pm 
New Member

Joined: Mar Wed 09, 2016 6:15 pm
Posts: 3
Many years ago, I developed a relational database using dBase III.

One database contained info on my radios and a second database contained a list of tubes in my stash.

The relational function gave me a printout of what tubes I used, the number of spares plus their location and which tubes I needed.

I tried to rewrite this for Access but Access was missing a very important function - Set Unique. This is required to sort out the tube numbers.

I don't know if the new version of Access has this function.

Other than running under DOS, dBase is still a very capable programme.

Allan


Top
 Profile  
 
 Post subject: Re: Excel file for managing tubes
PostPosted: Jan Sat 07, 2017 6:57 pm 
Member
User avatar

Joined: Jan Mon 18, 2010 2:13 am
Posts: 15384
Location: Dayton Ohio
Nothing wrong with DOS.
Its a very stable platform. Just not glitzy.

-Steve

_________________
Radio Interests
-Zenith
-Sparton
-Pre-War FM
Consoles and floor models, the bigger, the better!


Top
 Profile  
 
 Post subject: Re: Excel file for managing tubes
PostPosted: Feb Wed 01, 2017 6:20 pm 
New Member

Joined: Jan Sun 29, 2017 6:55 pm
Posts: 2
There is a Free Form Database program (free) that one can use for anything. I use it to manage articles from magazines, tubes etc. Easy to setup. I do not know about the knew version that is available now but my older version doesn't need to be installed. Just unzip it to one folder, even on a USB pen drive and keep your data files in that folder. This is my first post, so I can't put an link here so just google: TablePro


Top
 Profile  
 
 Post subject: Re: Excel file for managing tubes
PostPosted: Feb Wed 01, 2017 8:46 pm 
Member
User avatar

Joined: Mar Tue 04, 2014 3:29 am
Posts: 1994
Location: Long Beach, CA 90808
here is TablePro: http://softconstructors.com/en/applications/tablepro3/

_________________
Aloha, Ken

No Console Left Behind!
Come join us @ http://vintagehifi.net/


Top
 Profile  
 
 Post subject: Re: Excel file for managing tubes
PostPosted: Feb Fri 03, 2017 11:56 pm 
Member
User avatar

Joined: Jan Thu 01, 1970 1:00 am
Posts: 3392
Location: Olympia WA USA
I have a tube database on Open Office I created.
So far, over 5K listings of tube types and variants and nowhere near complete.

(I was going to open an online tube store, so I worked several hundred hours developing it, but then my fiancé got killed, and I lost interest. I may never finish it.)

_________________
FrankB
WB7ELC
Member: TCA & Steel Soldiers.
" Break down the wall"


Top
 Profile  
 
 Post subject: Re: Excel file for managing tubes
PostPosted: Feb Sat 04, 2017 2:33 am 
Member
User avatar

Joined: Jun Tue 17, 2008 4:52 am
Posts: 503
Location: Richmond Virginia U.S.A. 23224
ms access northwind sample database -free with ms office

_________________
Gary "JUKEBOXMAN"


Top
 Profile  
 
Post New Topic Post Reply  [ 18 posts ]  Moderator: Chuck Schwark

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 3 guests



Search for:
Jump to:  


















Privacy Policy :: Powered by phpBB