Welcome Guest! Be sure you know and follow the Phorum Rules before posting. Thank you and Enjoy! (January 12) x

Thread Closed
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5

How do you digitally organize your Philco collection?
#10

I also use Excel. I keep 2 workbooks that are continuously updated every time I buy or sell a radio.  One is a single sheet, row-per-radio list of models and values, which I update to my insurance agent about once a year.

The other is a ginormous workbook where I use a sheet-per-radio.  For a given radio purchase, I record a sheet with all the info that seems relevant... Seller's name, history of the set, purchase price, date, shipping costs, # of tubes and types used, # of bands, type of power supply, parts purchased, the price I sell it for, and the net amount I invested in that radio. Oh, and a photo, too. I paste a photo of each set into the sheet for that radio.

At the end of the workbook, I have a statistics sheet that totals up total # of radios bought and sold, average age, avg tube count, total and average-per-radio parts cost, total loss on sales, and anything else I'm interested in tracking.  I append new sheets at the end, between the most recent purchase and the statistics sheet, which must always be last. Then I copy-paste another sheet's contents to transfer the form layout to the new sheet.

And I back up my hard drive, yes.

-Rodney





Users browsing this thread:
[-]
Recent Posts
Philco model 38 code 121 not receiving signal.
So one last question before I finish this radio. Regarding the speaker and output transformer. I salvaged the original o...Stormlord5500 — 09:31 AM
462ron
It’s on the bottom of the homepage of our Philcoradio.com homepage! Ron462ron — 07:20 AM
Model 70 Cabinet Trim
Steve might have some trim left. Not sure he is making anything.morzh — 06:12 AM
Model 70 Cabinet Trim
Hello musar, First all welcome to the forum and yes that is true that steve stopped making trim . Sincerely Richar...radiorich — 12:13 AM
Model 70 Cabinet Trim
I have recently come into possession of a Model 70.  The trim around the base needs to be replaced.  If this were years ...musar — 12:07 AM
philcorepairbench.com - shadow-meter
Anyone know of a way to recover these files from the repair bench? Thanks. fenbach — 11:16 PM
Philco model 38 code 121 not receiving signal.
That's true. Of course If I were to get a vtvm I'd probably have to sink money in to it to get it working right. Probabl...Stormlord5500 — 08:44 PM
Philco model 38 code 121 not receiving signal.
A DMM is good enough. One rarely has to measure indictance, but if you do, short of getting a serious LCR meter (I hav...morzh — 07:35 PM
Testing a speaker and output transformer Trutone A2-G
You guy's are right on. I found a broken wire on the speaker plug that I replaced and all is well now. Have better volu...murf — 03:43 PM
Philco model 38 code 121 not receiving signal.
I need to get a vtvm. I think that little component tester is just more accurate. Plus it shows the inductance which is ...Stormlord5500 — 03:07 PM

[-]
Who's Online
There are currently 439 online users. [Complete List]
» 1 Member(s) | 438 Guest(s)
Avatar

>