Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5

How do you digitally organize your Philco collection?
#1

Hi Group - I recently had a hard drive failure in which I lost the fairly simple excel spreadsheet I used to track my Philco collection (of 150 plus radios) As I am starting anew, I am curious how others keep track of their collections - do you use a software program? have you created your own spreadsheet as I did? I would prefer not to start from scratch again, so I am hopeful others out there have some good ideas. -- Andy

Andy Sorrell
Palmyra, Virginia
#2

Try a search online.

IMHO the 'sheet should contain all the information that an insurance company or IRS would require in event of a loss or liquidation.

I search Google and this was on top:

https://americancollectors.com/agents/re...ory-sheet/

I downloaded a copy and it seems adequate. May want to add a column for images or links to images kept in a separate file.

I did craft a 'sheet when I gave some 60 items to a 501c3 museum. It worked O.K for me though the image handling was a bit quirky.

I have not been required to reveal the file other than include a print for my tax records...

I suppose I could strip a copy of my records and offer the blank file with all its headers?

Oh, I use Libre Office, I'm a Linux man...

GL

Chas

Pliny the younger
“nihil novum nihil varium nihil quod non semel spectasse sufficiat”
#3

Dear AV, you have learned the hard way what those of us who have used computers since the early days had drummed into us from early on. Keep you data files on separate media from your hard drive, or at least back the data files up regularly on separate media. I suggest that if your excel spread sheet worked well for you that you use one again. This time back it up on a thumb drive. I would have said floppy disk, but not many people have them in their computers any more. I am not familiar with Excel, but if it can, include a library of the pictures of your radios on the thumb drive, and have a links to the photos of each radio in the line for that particular radio. Finally, if you do not keep the first, working copy of your data file on the hard drive, then keep two copies on two different thumb drives just in case one has a problem some day, you will always have a good one to keep going.
#4

Save to Cloud? I am sure you will find a solution works for you. I knew one old timer kept a packet on each set, schematic, notes on work done, wrote on outside when acquired, where, from who, etc, kept them in a file like a dossier on each set, if he worked on one again more notes and into packet. If you got a set from him you got the info too.

Or just put them in the basement, wonder where they are, what you did with it, is it upstairs, did I sell it? Surely I jestIcon_smile.

Paul

Tubetalk1
#5

I have a NAS. Which is pretty much a server. With hard drives. I have it as mirrored RAID, so it is somewhat protected.
There I keep all that I would like to not easily lose.
Also it is in your home so you do not nee Cloud.

As for CLoud......I do not trust it. I do not trust something that is 1) on the Net and 2) does not wholly belong to me and is not in my house.
Also I do not have it as a server accessible from the outside, so.....I cannot access it, but so cannot others.

Oh....how I keep the collection notes.....well, I don't.
My collection is not huge so I know all that I have.
I have a mental picture of my basement and my workshop, and I can name all the radios, including where they stand and in what order.

People who do not drink, do not smoke, do not eat red meat will one day feel really stupid lying there and dying from nothing.
#6

Radios, Parts,tubes and everything else on Excel. They are backed up on no less than 4 devices, the easiest is a new 1TB (I think) thumb drive.

"I just might turn into smoke, but I feel fine"
http://www.russoldradios.com/
#7

I don't. I started thinning the herd a few years ago and I know what I have (and what else I need to get rid of).

If you need computer software to keep track of your radios, you might have too many. Icon_wink

--
Ron Ramirez
Ferdinand IN
#8

I don't digitally organize my Philco collection, mainly because most of my collection isn't made up of Philcos. I have just over a dozen, maybe a dozen and a half. I used to keep a log book of what I owned but gave up some years ago. It's a hobby, not a business, so I don't really see the need to keep an inventory of anything other then parts.
Regards
Arran
#9

I use Excel to keep track of my collection. It comes in handy when I want to see where, when, and from whom I bought a radio from. Since I collect a lot of obscure sets I also make notes about schematics, original manufacturer, etc.

As others have mentioned it's important to backup your hard drives. Personally I use external USB hard drives, but thumb drives, floppy disks or cloud storage also work, as long as you have a backup scheme and stick to a schedule.

John KK4ZLF
Lexington, KY
"illegitimis non carborundum"
#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
Jackson 715 not working
Now that you posted the schematic, I don't know why that Sprague electrolytic cap is across the meter, as it is not indi...MrFixr55 — 05:51 PM
HiFi (Chifi) tube amp build - but my own design.
What may be lacking in the PP Tube amps may be the 2nd harmonics, which some, especially RCA back in the day called &quo...MrFixr55 — 05:32 PM
Jackson 715 not working
Usually in an emission tester, the tube under test is measured as if it were a diode. So, some testers connect all the g...RodB — 04:17 PM
Restoring Philco 37-604C
Yep. F5 is green, D5 is Red. Red is Bad. Green is Clean.morzh — 01:30 PM
Jackson 715 not working
I did start to do that but I stalled out because I could not figure out how the grid and plate get voltage. In this diag...daveone23 — 11:52 AM
Restoring Philco 37-604C
(Insert Homer Simpson "DOPF" Here.) When all fails, look at the can. Took the Ron Ramirez advice, red Caig D...MrFixr55 — 09:23 AM
Philco 91 Speaker Replacement
From your text I am not sure if you intend to use the existing speaker with a resistor instead of the field coil. It wo...morzh — 08:44 AM
Philco 91 Speaker Replacement
My field coil is bad. I am still hoping to find an original, but if I can't I will go with a fitting Philco speaker, 125...dconant — 08:34 AM
Philco 91 Speaker Replacement
As Rod said, it is OK to use a fitting speaker, and then look for an original one. If you buy a Hammond 125 output tr...morzh — 08:15 AM
Philco 91 Speaker Replacement
Yes, I often have to substitute, then keep an eye out for an original. In the meantime, the radio is working and being e...RodB — 08:02 AM

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

>