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
Stromberg Carlson 1500 Squeal
And life just keeps getting more complicated. By dconant. Dittos'Jimradio — 08:01 AM
Plug Voltages Needed For A 1943 CRV-20130 Power Supply
That looks a lot like an aircraft connector of some kind, even if it's a U.S.N power supply. I have a book somewhere abo...Arran — 02:56 AM
Plug Voltages Needed For A 1943 CRV-20130 Power Supply
hello david, I have a similar generator in my collection that features a cast iron, single-cylinder Briggs & Stratt...radiorich — 01:00 AM
under chassis parts locator diagram for 1938 Zenith 9s262
Has anyone gone to the trouble of creating an under chassis parts locator image?  Yes, I can identify components by foll...bobloney — 08:57 PM
Plug Voltages Needed For A 1943 CRV-20130 Power Supply
Try looking at this site the book mark is for a old generator that I was given. David    https://radionerds.com/index.ph...David — 08:36 PM
Plug Voltages Needed For A 1943 CRV-20130 Power Supply
Hello Everyone, I am looking for voltage identification for all the pin positions on the socket of a CRV-20130 power su...Tonym4704 — 08:16 PM
Philco P45-6365 Universal Transformer Instruction Manual
Can anyone guide me to where this may be found?GRG — 03:00 PM
54C Complete Teardown/Rebuild
I don't think that I have encountered a 12Z3 before, curious how it uses one of those but includes a #43, which is a 25 ...Arran — 02:17 PM
HiFi (Chifi) tube amp build - but my own design.
It's the other forum. I'm also in DIY, but mostly read there. Honestly, I kinda jumped into this without much thought to...TV MAN — 10:43 AM
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

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

>