Quantcast
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

firearm inventory spreadsheet?

Discussion in 'General Gun Discussions' started by rondog, Feb 1, 2010.

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

    rondog Member

    Joined:
    Jun 29, 2007
    Messages:
    6,775
    Location:
    Commurado
    Does anybody have a nice "form", "template" or "spreadsheet", or blank document file in either Word or Excel for recording the information about your guns?

    I'd like to have an electronic copy of a blank form or template for recording make, model, serial number, description, value, etc., and maybe space for photos too. I have something similar in old printed paper forms, but those are pretty rough. I'd like something I could keep e-copies of, and make printed copies too.

    I can use Excel and Word, but I'm no good at creating templates. Anybody have something like this they'd share?

    Thanks!
     
  2. Carne Frio

    Carne Frio Member

    Joined:
    Aug 28, 2008
    Messages:
    745
    Location:
    Near Fairbanks
  3. CoRoMo

    CoRoMo Member

    Joined:
    Sep 21, 2007
    Messages:
    8,931
    Location:
    Californicated Colorado
    I could PM you with my Excel template, but I don't have it on this computer. What I need to do is email it to myself, that way it will be saved in that web email account and I could access it anywhere in the world just by logging into my account. A type of off-site archive.
     
  4. rondog

    rondog Member

    Joined:
    Jun 29, 2007
    Messages:
    6,775
    Location:
    Commurado
    That would be great! I'm not looking to buy any software, just an Excel spreadsheet that somebody made is great. Just a fill-in-the-blanks thing.
     
  5. Oro

    Oro Member

    Joined:
    Sep 22, 2007
    Messages:
    3,496
    Location:
    WA state
    em sent, email me back.
     
  6. paintballdude902

    paintballdude902 Member

    Joined:
    Jun 30, 2007
    Messages:
    2,872
    i just use the basic spread sheet i put make, model, serial number, caliber
     
  7. double bogey

    double bogey Member

    Joined:
    Dec 24, 2009
    Messages:
    382
    Location:
    Texas
    I just started an excel document, no template. Just started with gun #1, model, serial, description, and attached a picture. Then I made a bold border, went onto next gun. Saved it, put copy on a couple of cd's, one in gun safe, one to my brothers for safekeeping. Its eazy to add to or subtract from. Also it can be nearly infinite is size, however not a problem for me. If I get some time, I'll make an empty copy and post it here.
     
  8. rondog

    rondog Member

    Joined:
    Jun 29, 2007
    Messages:
    6,775
    Location:
    Commurado
    My email registered here is my home email, have to get back with ya when I'm home.
     
  9. Oro

    Oro Member

    Joined:
    Sep 22, 2007
    Messages:
    3,496
    Location:
    WA state
    Send me a pm then with the email you want it sent to just typed in the body of the pm. I'll send it and it will be there when you get home.
     
  10. leadcounsel

    leadcounsel member

    Joined:
    Jun 5, 2006
    Messages:
    5,365
    Location:
    Tacoma, WA
    I looked for a program, and someone here had one called gunlist or something similar. Software that I thought was overly complicated.

    I put mine on a simple Excell spreadsheet with make, model, serial, caliber, price paid, date, and other notes (finish, # or mags). When I make an update I email it to myself so that if I'm victim of theft or fire I have a permanent copy on email.
     
  11. W L Johnson

    W L Johnson Member

    Joined:
    Jun 16, 2008
    Messages:
    1,248
    Location:
    Kentucky
  12. Labyrinth666

    Labyrinth666 Member

    Joined:
    Nov 8, 2009
    Messages:
    107
    Location:
    Carmi, IL
    Why would you want records of every firearm you own? Maybe I'm paranoid, but I wouldn't want anyone to know any of that.
     
  13. W L Johnson

    W L Johnson Member

    Joined:
    Jun 16, 2008
    Messages:
    1,248
    Location:
    Kentucky
    If they are stolen or lost in anyway it's good to at least have a record of the S/N.
     
  14. leadcounsel

    leadcounsel member

    Joined:
    Jun 5, 2006
    Messages:
    5,365
    Location:
    Tacoma, WA
    It only comes into play for insurance purposes or police reports of theft, or to record the disposition. And sometimes I just like to look at my list! :) In my graying years it's a good reference as to where, when and how much my guns were. And emailing it to myself creates a timestamp.
     
  15. double bogey

    double bogey Member

    Joined:
    Dec 24, 2009
    Messages:
    382
    Location:
    Texas
    Is there a way to attach an excel sheet?
     
  16. W L Johnson

    W L Johnson Member

    Joined:
    Jun 16, 2008
    Messages:
    1,248
    Location:
    Kentucky
    Attach it to what? If an E-mail there should be an attach button in whatever e-mail program you are using then it's just a matter of selecting the right file.
     
  17. double bogey

    double bogey Member

    Joined:
    Dec 24, 2009
    Messages:
    382
    Location:
    Texas
    There is an attach button in the advanced reply section, it will accept word docs but not excel. I wanted to attach the sheet I used.
     
  18. W L Johnson

    W L Johnson Member

    Joined:
    Jun 16, 2008
    Messages:
    1,248
    Location:
    Kentucky
    That's weird, It shouldn't care what type of file you are attaching unless it's trying to insert it into the e-mail instead of attaching it to the e-mail. What E-mail program are you using?
     
  19. BCCL

    BCCL Member

    Joined:
    Feb 3, 2009
    Messages:
    1,438
    Location:
    So. Illinois
    I just keep my list in a free text file encryption program called LockNote.exe.
     
  20. Milkmaster

    Milkmaster Member

    Joined:
    Dec 29, 2006
    Messages:
    2,020
    Location:
    Murfreesboro, TN
    Most email servers like Comcast for instance allows several meg of free storage. You don't have to store it in an email. The email service will have instructions on how to access the files.

    I have pictures of each of my firearms along with a word document list with serial numbers etc. Any time the list changes I just overwrite the previous edition with a new one. If they are stolen or a fire burns up my house, the firearms will be replaced.

    I also take a video of the contents of my home once per year and store the file there as well. The insurance adjuster tells me that it is the number one problem when folks lose their home. Remembering everything they have to list for insurance purposes.
     
  21. double bogey

    double bogey Member

    Joined:
    Dec 24, 2009
    Messages:
    382
    Location:
    Texas
    Not talking about email, talking about replies to a thread in this forum.
     
  22. obm

    obm Member

    Joined:
    Jul 22, 2005
    Messages:
    182
    Location:
    USA
    Google Docs

    I use the Google Docs spreadsheet:

    http://docs.google.com

    I have one sheet for firearms inventory, one sheet for a shoot log which acts as an odometer for each firearm.

    I also keep track of other stuff like my weekly cycling log to log my miles, average speed, time, etc.

    sorry no fancy templates, just basic column headings at top.

    -obm
     
  23. Magic_Man

    Magic_Man Member

    Joined:
    Dec 29, 2007
    Messages:
    540
    Location:
    PA
    I made my own in Excel. I use it to keep track of firearms I currently own, ones I have sold, ammo inventory, accessories & money spent, etc.
     
  24. double bogey

    double bogey Member

    Joined:
    Dec 24, 2009
    Messages:
    382
    Location:
    Texas
    Yes, I built one with excel, I was trying to post a sample someone could use easily. Oh well they aren't that hard to make.
     
  25. hadmanysons

    hadmanysons Member

    Joined:
    Nov 5, 2008
    Messages:
    582
    Location:
    Arkansas
    I use GunSafe. It works great for my purposes, which is record keeping, possible theft and gee wiz purposes
     
Thread Status:
Not open for further replies.

Share This Page