Quantcast

Spreadsheet for Gun Info

Discussion in 'General Gun Discussions' started by dwstinge, Feb 19, 2009.

Thread Status:
Not open for further replies.
  1. dwstinge

    dwstinge Member

    Joined:
    Jan 18, 2009
    Messages:
    32
    Does anybody have a spreadsheet for keeping up with all their gun info that they would like to share? A friend at work had a few guns stolen and couldn't come up with the serial numbers so I figured I better do something for mine. I know its easy to make one myself but I would like to see how some other people do theirs. Thanks in advance.
     
  2. dogtown tom

    dogtown tom Member

    Joined:
    Jan 15, 2006
    Messages:
    4,919
    Location:
    Plano, Texas
  3. DoubleTapDrew

    DoubleTapDrew Member

    Joined:
    Feb 23, 2006
    Messages:
    5,356
    Location:
    Oregon
    GunSafe works good and is free. Keep a backup copy somewhere else in case of fire/computer theft.
     
  4. Nugilum

    Nugilum Member

    Joined:
    Dec 17, 2007
    Messages:
    1,003
    Location:
    Texas Panhandle
    I'll PM you with a general version of what I use. You can't post spreadsheets here.
     
  5. cbrgator

    cbrgator Member

    Joined:
    Jan 23, 2008
    Messages:
    2,525
    Anybody know how to add a manufacturer in Gunsafe? There is no Stag.
     
  6. 230RN
    • Contributing Member

    230RN Marines raising the left-leaning Pisa tower.

    Joined:
    May 27, 2006
    Messages:
    6,632
    Location:
    Calirado
    I've just got a list. Gun, caliber, sn, attachments (scope, sling, etc) modifications, alterations, distinguishing characteristics, history,etc. Easy to add to, edit, delete, and very flexible.

    And I can be as verbose as I want.

    I have a shortcut to it on my desktop, so if something occurs to me at any old odd time, I just click and type.

    However, I am thinking of putting it on a flash drive and taking it off the computer itself, even though it's not on my C:\ drive, along with other sensitive information.

    I send copies to my sons if there are any changes.
     
  7. Kind of Blued

    Kind of Blued Member

    Joined:
    Sep 7, 2007
    Messages:
    3,676
    Location:
    Rocky Mountains
    Microsoft Excel and analytical people go together incredibly well. I use it to record every gun I own, including date purchased, purchase price, MSRP, where I bought it, the caliber, serial number, who I want it to go to if I die, identifying markings, etc, etc. I've actually included everything of value that I own, or anything which includes a serial number. Of course, my laptop is included in the spreadsheet, so the file is e-mailed to myself every time I update it. I'll also print a hard copy or two and put those in a couple places.

    Now if you want to talk about nerding out with Excel, I also have an Excel "program" which rate guns on how good they would be as carry guns. I have 30 or so fields with a certain number of points assigned to each, and I input the data of a particular gun and the program calculates a percentile for me.

    I also have a program which I use to keep track of certain rare guns that sell (or fail to sell) on GunBroker. Buy-it-Now prices, reserve prices, bids, bidder names, winning bidders names, whether the original box and grips were included, condition etc. are all recorded. This gives me a good idea of what discontinued models are selling for in today's market, and what factors effect the price.

    I have more time and skills than I do money. ;)
     
  8. czarjl

    czarjl Member

    Joined:
    Jan 5, 2009
    Messages:
    156
    Location:
    Western NY
    This is my list... well at least part of it.
    I have it in Excel and I e-mail my self a password protected copy. That way if I need the info I have it somewhere other than in my computer or the printed copy with all my other paper work (if I lose everthing I still have my list to cry over).
     

    Attached Files:

  9. zoom6zoom

    zoom6zoom Member

    Joined:
    Apr 24, 2006
    Messages:
    2,908
    Location:
    Virginia
    If you want to use an Excel file but don't have or want M$ Office, grab a copy of OpenOffice. It's free, and compatible with Office files. I've pretty much dumped Office on all our machines.
     
  10. dirt_j00

    dirt_j00 Member

    Joined:
    Sep 16, 2008
    Messages:
    310
    Location:
    Montgomery, AL
    cbrgator - to answer your question: go here - http://www.somanyroads.org/gunsafe/, then look at #1 toward the bottom. I think that is what you need.

    Here are the fields I use on my excel .xls to keep up with my firearms:

    Type,Make,Model,Caliber,Finish,Stock,Serial Number,Notes

    and for scopes:

    Make, Model, Model Number

    Including the price you paid for it could be helpful too...think I'll borrow that idea!
     
  11. dwstinge

    dwstinge Member

    Joined:
    Jan 18, 2009
    Messages:
    32
    So before I download gunsafe how do I back it up? I like the idea of emailing myself a spreadsheet.
     
  12. Duke of Doubt

    Duke of Doubt member

    Joined:
    Dec 29, 2008
    Messages:
    2,863
    dwstinge: "I like the idea of emailing myself a spreadsheet."

    As a survivor, many years ago, of the Big Sux ... seek counselling, my young friend.
     
  13. Sav .250

    Sav .250 Member

    Joined:
    Jun 5, 2007
    Messages:
    3,691
    Location:
    Central Fla
    I`ve got pictures of mine with all information on the back.
     
  14. Duke of Doubt

    Duke of Doubt member

    Joined:
    Dec 29, 2008
    Messages:
    2,863
    Sav .250: "I`ve got pictures of mine with all information on the back."

    Circles, arrows, paragraphs on the back of each one explaining what each one was and how it was to be used as evidence against you?

    Unwise.
     
  15. TimRB

    TimRB Member

    Joined:
    Jan 27, 2004
    Messages:
    922
    Location:
    CA
    "Circles, arrows, paragraphs on the back of each one explaining what each one was and how it was to be used as evidence against you?

    Unwise."

    Tin foil hat chafing a bit today Duke?

    Tim
     
  16. heron

    heron Member

    Joined:
    Apr 26, 2007
    Messages:
    1,062
    Location:
    NE Ohio
    I have scanned images of the original receipts for all my guns, and save them to a USB memory stick. Just put them all in one dedicated folder. I also have the same folder on my hard drive. Since the scanner arbitrarily assigns the document title as an alphanumeric designation, I simply change that to whatever I like. This works fine for me, but then, I only have five guns.
     
  17. Duke of Doubt

    Duke of Doubt member

    Joined:
    Dec 29, 2008
    Messages:
    2,863
    TimRB; "Tin foil hat chafing a bit today Duke?"

    Not really. Suppose a loved one allegedly stole one of your guns, allegedly used it allegedly to shoot her not-so-alleged rapist and batterer and, of all things, the alleged weapon somehow was recovered near the scene. Your home is searched. No report of the stolen gun has ever been filed. Whether any record of said gun is found in searches of computer hard drives or discs is a direct function of your tinfoil hat quotient, I imagine.

    Yes, that pretty much happened to a family member of a client (elsewhere, elsewhen).
     
  18. knockonit

    knockonit Member

    Joined:
    Jul 21, 2007
    Messages:
    196
    Location:
    Phoenix Arizona
    gunsafe

    the program has a edit portion for every section, go to main menu, pick manufacture, then scroll down alphabet , go to top menu click on new and add name, easy as one two three.

    I have quite a collection and use this, if you're concerned about the tin foil aspect, put it on a flash drive, or like I did, I put it on a flash drive (two) and a disc, which I put in safe deposit box.

    It is a great program and the best is its free to download.
    I no longer have to itemize my stuff for insurance reasons, the fact that I have it serialized, pictured and detail description is enough for the leeches.
    good luck with it, was a boon to me.
    rj
     
  19. TimRB

    TimRB Member

    Joined:
    Jan 27, 2004
    Messages:
    922
    Location:
    CA
    Uh...okay.

    How about this: Suppose your gun is stolen. The police recover one just like it, and ask you what the serial number of your gun is. You say "I dunno." The police then say "Sorry, we can't help you."

    Tim
     
  20. Duke of Doubt

    Duke of Doubt member

    Joined:
    Dec 29, 2008
    Messages:
    2,863
    TimRB: "How about this: Suppose your gun is stolen. The police recover one just like it, and ask you what the serial number of your gun is. You say "I dunno." The police then say "Sorry, we can't help you.""

    Sounds good to me. Like the girl all over me last night, I don't know where that gun has been, now.
     
  21. boondockcrain

    boondockcrain Member

    Joined:
    Dec 27, 2008
    Messages:
    31
    Location:
    Clay County Illinois
    All I get when I download is a search screen ???
     
  22. sqlbullet

    sqlbullet Member

    Joined:
    Jan 16, 2008
    Messages:
    445
    I don't think you really need this. Our new president is planning on keeping track of all that for you.
     
  23. Duke of Doubt

    Duke of Doubt member

    Joined:
    Dec 29, 2008
    Messages:
    2,863
    Our new President couldn't keep track of a falling Chrysler.

    Where is the Man in the Yellow Hat?
     

    Attached Files:

  24. statelineblues

    statelineblues Member

    Joined:
    Jul 9, 2006
    Messages:
    836
    Location:
    In PA
    No, I think Duke was just having an Arlo Guthrie moment....:D

    "I had to pay $50.00 and pick up the trash."
     
    Last edited: Feb 21, 2009
Thread Status:
Not open for further replies.
  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