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: 2 Guest(s)
[-]
Recent Posts
My last cabinet for this year
Hello Dan, That is really beautiful what great looking radio you have ! I have friends who live in Calgary and the wea...radiorich — 01:51 AM
12' Philco
Not anymore Mike. Andre The Giant Born: May 19, 1946, Coulommiers, France Died: Jan 28, 1993 (46 years), Paris, Fran...RodB — 11:53 PM
IF can wire size and Rubber mounts?
Renovated Radios do carry what you need. As for the voltage, a wire should be at least 300V-rated.morzh — 11:13 PM
12' Philco
Andre the Giant got 2" on Kareem :lol:morzh — 11:11 PM
IF can wire size and Rubber mounts?
Thanks for the info but I doubt that a hardware store would be carrying the proper tuner assembly support mountings for ...georgetownjohn — 10:38 PM
12' Philco
Perhaps Kareem Abdul Jabbar?GarySP — 10:33 PM
My last cabinet for this year
Outstanding work, Dan! Take care and BE HEALTHY! GaryGarySP — 10:31 PM
My last cabinet for this year
They are a nice looking radio, Stromberg. I have a small tabletop octagon-dial one. It sounds surprisingly nice. And t...morzh — 09:40 PM
Philco 41-608 changer coupler
Different years but the same idea.morzh — 09:38 PM
My last cabinet for this year
That’s a beauty! :thumbup:klondike98 — 09:24 PM

[-]
Who's Online
There are currently no members online.

>