Quantcast

Best way to inventory gun collection?

Discussion in 'General Gun Discussions' started by Kingcreek, Feb 3, 2019.

  1. Kingcreek

    Kingcreek Member

    Joined:
    Dec 24, 2002
    Messages:
    3,020
    Location:
    at the center of my own little universe
    i spent a good part of a day taking pics and recording serial numbers, details, history, and approx value on all my firearms. Right now it’s pics on a flash drive and paper but I would like to put it all on a flash drive and keep in the safe deposit box. I don’t have excel but have a windows laptop. Any suggestions for freeware or ?
    Somebody suggested mygundb.com but the free version is only 10 guns max. I need quite a bit more and would also like to list some custom knives too.
    Thanks in advance
     
  2. Havok7416
    • Contributing Member

    Havok7416 Member

    Joined:
    Apr 24, 2012
    Messages:
    2,727
    Location:
    Kentucky
    Google Documents is free and you can access your content anywhere you have an internet connection. You can download the documents to whatever device you happen to be using.
     
    kilizyrag and shoobe01 like this.
  3. gulogulo1970

    gulogulo1970 Member

    Joined:
    Jul 29, 2003
    Messages:
    985
    Location:
    Fort Worth, Texas
    I like LibreOffice. Works like Word and Excel and it is free.
     
    AZAndy likes this.
  4. dh1633pm

    dh1633pm Member

    Joined:
    Apr 28, 2009
    Messages:
    1,880
    Location:
    Central New York
  5. CapnMac

    CapnMac Member

    Joined:
    Feb 27, 2009
    Messages:
    3,584
    Location:
    DFW (formerly Brazos County), Texas
    Sadly, the easiest way is one at a time. (Yeah, duh.)

    I've never found an off the shelf version that did what my built-to-suit spreadsheet one does.

    Now, for 2¢, were I starting over, I'd set up a spreadsheet with a summary first page, and a workseet for each firearm. This would help manage the data a bit better. You'd want to design the worksheets so that the same cell always had things like price paid, trade-in, if-sold value, replacement value, etc., to make the summary easier. Only down side there is that the worksheets would be slightly harder to "group" by features (like "pistol," "revolver," carbine, etc.) Not impossible, just a tad more complicated than using a Sort function.

    Now, storing such thing in Google Docs or iCloud, or DropBox, can make sense--just, please, encrypt those files first, please.
     
  6. Sovblocgunfan

    Sovblocgunfan Member

    Joined:
    Mar 10, 2015
    Messages:
    838
    Location:
    Spring TX
  7. FROGO207

    FROGO207 Member

    Joined:
    Dec 7, 2008
    Messages:
    7,710
    Location:
    Mount Desert Island Maine
    CapnMac has the right Idea. That is what I did, with a minimum of 8 high quality photos showing distinguishing features, SN, etc. I recorded other data I wanted to save as well on the drives. I have three thumb drives at three distant secure locations for storage. If all three of them and my laptop disappear at once worrying about any firearms will not be on the radar. It is nice when the local authorities want info on a stolen item you have it all there on a portable drive almost instantly. I learned this the hard way and had to back track some to get a SN for them once. Now I can just Email the info.
     
  8. larryh1108

    larryh1108 Member

    Joined:
    Aug 29, 2008
    Messages:
    2,656
    Location:
    NC
    I also use Libre Office.
    It's just like Excel and it's free.
    If you'd like (or anybody) I can email a program that I wrote that
    tracks my guns, ammo and reloading supplies with a running total of $$.
     

    Attached Files:

    Riomouse911 and bob_atl like this.
  9. DukeConnor

    DukeConnor Member

    Joined:
    Oct 30, 2016
    Messages:
    192
    take a pic of the paper and put it on the flssh drive.
     
  10. Sypher....

    Sypher.... Member

    Joined:
    Jan 19, 2019
    Messages:
    50
    Would you mind sharing an example?
     
  11. OARNGESI

    OARNGESI Member

    Joined:
    Sep 9, 2011
    Messages:
    1,055
    I wonder how hard it would be to create a app that constantly searches gunbroker and updates values, it may be a good to show your wife look honey I spent 40k in guns but now they are worth 60k.
     
  12. Telekinesis

    Telekinesis Member

    Joined:
    Jan 23, 2011
    Messages:
    1,666
    Location:
    Birmingham, Alabama
    Making a webscraping program isn't hard (lots of them are already out there). The difficult part is making sure you're looking at the right values and the right guns, and then have the program do a good analysis.

    You'd need to control for key words in the description as well - things like round count, wear, age, and especially things that make a gun "special" and sell for more than a normal version. Things like a connection to a notable figure, a rare stainless version, etc.

    Ideally, you'd build an advanced analytical program that would correate ask and sale price with words in the description and potentially image recognition which would key off of signs of wear.

    Getting the data is easy, describing what it means is more difficult.

    OP, Libre Office is a good alternative to Excel. Very similar, just not quite as easy to navigate and has some quirks on the more advanced features, but none of that should cause issues. I would highly recommend you keep the data local and not upload it to a cloud server or google docs unless it is encrypted.
     
  13. kheeka

    kheeka Member

    Joined:
    Mar 29, 2018
    Messages:
    33
    Dont use Google Docs if you want it to be secure. Google looks at everything plus it is on the cloud. Nothing on the cloud is secure.

    Open Office is a free download and works very well, spreadsheets and everything Excel and Word does.
     
    Charlie Horse likes this.
  14. George P

    George P Member

    Joined:
    Jan 10, 2018
    Messages:
    2,814
    Send yourself an email with everything as well as keep the drive someplace safe.
     
  15. bob_atl

    bob_atl Member

    Joined:
    Dec 23, 2018
    Messages:
    62
    Also use the free spreadsheet in Libre Office. (it can be password protected)
    simple one line per gun format.
    also take pictures of each one including its serial number.
    Those two ways are enough for me.

    George P, you must encrypt the emails to yourself, but I would not go that route.
     
  16. hdwhit

    hdwhit Member

    Joined:
    Nov 16, 2015
    Messages:
    4,648
    Location:
    Frisco, TX
    Make a list of the gun, date of acquisition, price paid, and serial number on a piece of notebook paper. Take several pictures of each gun, including a close-up of the serial number. Print out the pictures at your local drug store. Put the photographs and list in a manila envelope and stick the envelope in your safe deposit box.

    Done.

    No need to worry about indexing software, electronic media, whether the format will be compatible when you need to read the images or any of that; just a contemporaneous written record accompanied by photographs.

    If you used a digital camera to take the pictures, you can, of course, download the pictures onto a flash drive, but if you're really concerned about longevity then you also need to burn a DVD of the images so that you don't have to worry about electromagnetic pulses wiping the flash drive.
     
  17. lightman

    lightman Member

    Joined:
    Feb 7, 2011
    Messages:
    1,303
    Location:
    england,ar
    I did it the old fashioned way. I just typed up a list. It includes make, model, caliber, sn, any distinguishing features and any info like inherences, gifts to/from ect. Also, some of my scopes and binoculars have serial numbers that are also listed.
     
  18. Hasaf

    Hasaf Member

    Joined:
    Dec 10, 2017
    Messages:
    709
    Location:
    Kansas
    I use a Google sheet.. I have one page for what I have:
    Count, Manufacturer, Type, Model, Caliber, Serial #, Purchase price, Purchase Date, Purchased From, Barrel (in.), Length, Hight, Thickness, Weight (oz.), Measured Weight (oz.)

    Then I have a couple other worksheets, one for accessories:
    Manufacturer, Type, Model, SKU#, Own-S/L (do I own it or is it a short list accessory), Installed on?, Price, Purchase Date, Notes:

    Then I have my shortlist of guns I am looking at, this helps keep me focused.
    Manufacturer, Type, Model, Caliber, Stock #, price, Order of Interest, Comment:

    And one more fo guns that I am interested in for some reason, but they are not on my shortlist:
    Manufacturer, Type, Model, Caliber, Stock #, price, Reason not Short-Listed

    Them I have a sheet for sold and one for "not in possession" this is things like a 22lr that I loaned my sister and a rifle at a friends that I put in his safe when I was leaving the country several decades ago. t also is where I list stolen firearms.
     
  19. dh1633pm

    dh1633pm Member

    Joined:
    Apr 28, 2009
    Messages:
    1,880
    Location:
    Central New York
    Does everyone trust Google to keep your stuff secure? Remember anything that is free means that "you are the product". Whatever product you use, you have to maintain security over it, be it a program, a file, or even a picture. If someone has a spreadsheet they think works well, save a copy, remove your data, maybe input example data, and then upload it so others can check it out. Why should so many have to re-invent the wheel.
     
  20. Havok7416
    • Contributing Member

    Havok7416 Member

    Joined:
    Apr 24, 2012
    Messages:
    2,727
    Location:
    Kentucky
    I have zero issues with Google. My spreadsheets include all relevant info for my guns, but the guns are still stored securely. All actual pictures (which includes serial numbers where it's convenient to do so) of my guns stay on local hard drives.
     
  21. jeepnik

    jeepnik Member

    Joined:
    Sep 25, 2011
    Messages:
    1,976
    Location:
    SoCal
    I use excel. Firearms are broken down into categories. Each firearms data is linked to attached photos. The live document is kept in excel my copies are converted to PDF.
     
    bob_atl likes this.
  22. Hasaf

    Hasaf Member

    Joined:
    Dec 10, 2017
    Messages:
    709
    Location:
    Kansas
    Here you go, a copy of what I use, with some example data. It is set to view only. To use it you will need to make a copy.
     
    bob_atl likes this.
  23. FL-NC

    FL-NC Member

    Joined:
    Feb 10, 2016
    Messages:
    4,507
    Location:
    Fl panhandle
    Take a pic, send it to yourself as an email with the serial #, and store in a folder. If you do it one at a time, you can delete any guns you get rid of. Its foolproof, and even if your computer gets stolen the record will still exist.
     
  24. bob_atl

    bob_atl Member

    Joined:
    Dec 23, 2018
    Messages:
    62
    Sending yourself an email opens that data up to external/government scrutiny -- despite any laws of privacy.
    At least encrypt it, but even that is suspect.
     
  25. minuteman1970

    minuteman1970 Member

    Joined:
    Sep 20, 2005
    Messages:
    98
    Location:
    Long Island, NY
    I would not trust Google with owned firearm data. Keep an Excel or some other spreadsheet offline and back it up using multiple thumb drives kept in different locations.
     
    bob_atl likes this.
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice