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 42-345 Restoration/Repair
Hi OSanders, Look carefully at the band switch. Turn it slowly and "wiggle" it around the desired band. ...MrFixr55 — 12:33 AM
5U4 vs 5Z4 tubes
I think that RCA and GE introduced metal tubes in the USA in 1936.  I don't know if they were being made by RCA, GE or b...MrFixr55 — 11:20 PM
Philco 42-345 Restoration/Repair
Vlad95, Thank you for the stringing guides and wow there are so manyosanders0311 — 06:01 PM
5U4 vs 5Z4 tubes
A pre war Hallicrafters, and an early one too, very nice! 1936 is pretty early for metal tubes too, which would explain ...Arran — 05:58 PM
Philco 42-345 Restoration/Repair
Thanks Rod, "When you hear the background hiss and no station it usually indicates that the oscillator quit" ...osanders0311 — 05:52 PM
Philco 42-345 Restoration/Repair
RodB :beerchug:Vlad95 — 10:22 AM
Philco 42-345 Restoration/Repair
Vlad, you nailed it. Swiss and German roots.RodB — 09:54 AM
5U4 vs 5Z4 tubes
Well this is a Hallicrafters SX/9 circa 1936. No real issues so far although I dodged a real bullet with a cap that was...bridkarl — 07:59 AM
5U4 vs 5Z4 tubes
The pinout is the same but the 5U4 has a 3 amp filament, verses 2 amps or less on the 5Z4. I think that the pinout of a ...Arran — 12:04 AM
Philco 42-345 Restoration/Repair
By the way. osanders0311 Take a look here: Dial cord stringing Guides May be here you can fount correct string settin...Vlad95 — 11:15 PM

[-]
Who's Online
There are currently 1336 online users. [Complete List]
» 2 Member(s) | 1334 Guest(s)
AvatarAvatar

>