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: 1 Guest(s)
[-]
Recent Posts
Philco model 40-100
That was part pf what began my interest in tube battery radios, the variety of circuit designs, especially by Grimes-Pho...Arran — 02:37 PM
Studebaker/Philco AC-2687 car radio
Phill; I had a look at my Riders "Specialized" car radio books yesterday, I don't have one that covers Stud...Arran — 01:50 PM
Philco Model 249 made in England
Thanks for the information MrFixr55.   It's tube amplification and not solid state. TOMfklown — 11:27 AM
Philco Model 249 made in England
Well, I’ll be! I learned something.jrblasde — 11:03 AM
Philco Model 249 made in England
Yes, Garrard was well-regarded for its standalones.morzh — 10:48 AM
Philco 46-480 Electronic Restoration
Quite the interesting stories, sir! Somewhat reminds me of my first job out of school (not that I worked in a similar fi...jrblasde — 09:33 AM
Philco model 40-100
Arran, I restored 2 Canadian battery-crank telephones for a friend a while ago, a Northern Electric (Canadian version of...MrFixr55 — 08:04 AM
Road Trip for a Philco 46-480
Beautiful work, a 79 year old radio brought back to life. The first FM radios for me, a little iffy, had some I just cou...Jimradio — 08:01 AM
Philco 46-480 Electronic Restoration
I was a field engineer for a biomedical company for many years. Many was the time that I was driving home from NYC in t...MrFixr55 — 06:40 AM
Philco 46-480 Electronic Restoration
Don't laugh folks, I have not been above taking a chassis into the bathtub (when Ms. Fixr was out of the house), taping ...MrFixr55 — 06:02 AM

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

>