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

Thread Closed

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 71 Code 125
Hello,  I am in need of a schematic for this radio. Mine has the three separate circular tube shields and a shadow me...dconant — 08:06 AM
Stromberg Carlson 1500 Squeal
And life just keeps getting more complicated.dconant — 07:57 AM
54C Complete Teardown/Rebuild
Hello Roy, here is this one sincerely Richardradiorich — 12:45 AM
54C Complete Teardown/Rebuild
Richard, Had grabbed it already but thank you just the same.  I find myself wanting to find some way to block out the...glyphmon — 12:03 AM
54C Complete Teardown/Rebuild
Hello roy, here is a link to the schematic . Sincerely Richardradiorich — 11:54 PM
54C Complete Teardown/Rebuild
Richard, The Silvertone 2014 also is a transformerless set, so I am incorporating a 1:1 600 ohm audio isolation transfo...glyphmon — 11:37 PM
Preliminary work on wife's Silvertone 2014
Did an alignment today which was interesting.  IF alignment went great, almost all was already spot-on.  Adjusting on th...glyphmon — 11:35 PM
54C Complete Teardown/Rebuild
The main problem with adding a Bluetooth input is that this set lacks a traditional power transformer to isolate it from...radiorich — 11:19 PM
54C Cabinet Refinish
I started stripping this cabinet before it got super chilly out because I knew I wasn't going to be able to work on ...glyphmon — 11:18 PM
54C Complete Teardown/Rebuild
While I'm waiting to wrap up the final steps on my wife's Silvertone 2014, I started disassembly on the next project.  O...glyphmon — 11:07 PM

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

>