close

Privacy guaranteed - Your email is not shared with anyone.

Firearm Spreadsheet

Discussion in 'General Firearms Forum' started by Hines57, Jul 4, 2012.


  1. Hines57

    Hines57
    Expand Collapse
    Simple Member

    Joined:
    Jan 17, 2001
    5,441
    501
    Location:
    On the road
    I know they have been posted here before, but I can't find one. Anybody have an inventory spreadsheet they can share? Preferably one that includes photos.

    Thanks
     

    Wanna kill these ads? We can help!
  2. LabTech

    LabTech
    Expand Collapse
    Village Jackass

    Joined:
    May 23, 2005
    960
    0
    Location:
    Scenic southeast Ohio
    Tagged.
     

  3. racer88

    racer88
    Expand Collapse
    NRA & SAF mbr

    Joined:
    Oct 14, 2009
    2,594
    52
    I'm using MyGunDB and like it fairly well. A few features I'd like see added (ammo inventory). But, for most people, it's a great way to keep track of firearms and related info.

    http://mygundb.com/
     
  4. Hines57

    Hines57
    Expand Collapse
    Simple Member

    Joined:
    Jan 17, 2001
    5,441
    501
    Location:
    On the road
    That looks cool, maybe a bit more then I am really looking for. Would like to find a free one.
     
  5. bac1023

    bac1023
    Expand Collapse

    Joined:
    Sep 26, 2004
    100,332
    1,832
    Location:
    PA
    I just use Excel and build the spreadsheets myself.

    It works great.
     
  6. unit 900

    unit 900
    Expand Collapse

    Joined:
    Sep 3, 2000
    683
    27
    Location:
    Baltimore, Md
  7. Quiet

    Quiet
    Expand Collapse
    Casino Goon

    Joined:
    Mar 25, 2007
    1,766
    0
    Location:
    bouncing between the 909 & the 702
    BATFE Personal Firearms Record

     
  8. oily_oink

    oily_oink
    Expand Collapse
    ###########

    Joined:
    Jun 23, 2006
    4,329
    2
    Location:
    Metro. Detroit
  9. M2 Carbine

    M2 Carbine
    Expand Collapse

    Joined:
    Dec 21, 2002
    20,888
    3,317
    Location:
    Texas
    +1

    You can make it as simple or as detailed as you want.
     
    #9 M2 Carbine, Jul 5, 2012
    Last edited: Jul 5, 2012
  10. racer88

    racer88
    Expand Collapse
    NRA & SAF mbr

    Joined:
    Oct 14, 2009
    2,594
    52
    Just me... but $40 is a bargain for a really cool program... and it saves me a LOT of time (trying to set up a good spreadsheet).

    http://mygundb.com/

    Free updates, and he updates it a LOT (plus he's very receptive to suggestions for new features. I just updated mine last night, and it appears he has added a good ammo inventory feature! I haven't explored it, yet, though.

    MyGunDB is very comprehensive. Photos, purchase records, ammo usage and count, accessories for each gun, maintenance records, etc., etc. Check it out! (I have no financial interest or any connections to this company other than being a customer.)

    Why make it difficult on yourself or time consuming? I don't have time to reinvent the wheel. $40 via paypal, and I'm off to the races!
     
  11. fnfalman

    fnfalman
    Expand Collapse
    Chicks Dig It

    Joined:
    Oct 23, 2000
    49,238
    2,231
    Location:
    California & New Mexico, US
    I had a spreadsheet that lists the guns by manufacturers, model numbers and calibers. I haven't updated it in years. Don't even know which computer the spreadsheet is on.
     
  12. Bren

    Bren
    Expand Collapse
    NRA Life Member

    Joined:
    Jan 16, 2005
    39,379
    4,872
    Location:
    Kentucky
    I've been meaning to do this - Probably just make it a word document with pictures and then convert it to pdf.
     
  13. racer88

    racer88
    Expand Collapse
    NRA & SAF mbr

    Joined:
    Oct 14, 2009
    2,594
    52
    I had been planning to do this for a long time, and this thread inspired me to finally do it... inventorying my ammo! That took some work! And, I've got more ammo than I realized!

    MyGunDB has a place to inventory ammo in the program. A cool feature is that you can then display the ammo that corresponds (by caliber) to each firearm in your database. Then you can subtract ammo from the inventory and simultaneously add it to the ammo count for that particular firearm. Very cool!!

    I've also just emailed the owner / programmer of MyGunDB with a couple of additional suggestions for the ammo section (to make it easier to add to the inventory as new ammo is purchased).
     
  14. Cobra64

    Cobra64
    Expand Collapse
    Deals in Facts

    Joined:
    Jan 15, 2007
    13,433
    1
    Location:
    Depends on where I am.
    :agree:
     
  15. PzGren

    PzGren
    Expand Collapse

    Joined:
    Feb 21, 2001
    2,244
    70
    Location:
    Pembroke Pines, FL, U.S.A.
    Great minds think alike:cool:.
     
  16. efman

    efman
    Expand Collapse

    Joined:
    May 22, 2005
    320
    4
    Location:
    georgia
    tag for the good info
     
  17. The_Gun_Guru

    The_Gun_Guru
    Expand Collapse
    Ban Democrats!!

    Joined:
    Jul 14, 2006
    7,802
    224
    Location:
    Where English and NYer's Go to Die!
    I put all my receipts in envlopes and keep them in the safe.

    Do you know how long it would take me to put them into Excel?

    I don't have that kind of time!


    TGG
     
    #17 The_Gun_Guru, Jul 6, 2012
    Last edited: Jul 6, 2012
  18. M2 Carbine

    M2 Carbine
    Expand Collapse

    Joined:
    Dec 21, 2002
    20,888
    3,317
    Location:
    Texas
    I can't imagine what a chore it would be to inventory my ammo.
    Then trying to keep up with what I shoot and buy/reload would be a royal PITA.
     
  19. SigFTW

    SigFTW
    Expand Collapse

    Joined:
    Nov 4, 2010
    2,384
    30
    Location:
    TX
  20. racer88

    racer88
    Expand Collapse
    NRA & SAF mbr

    Joined:
    Oct 14, 2009
    2,594
    52
    Now that I've done the initial data entry, it should be quite easy. When I buy some, I'll add it to the DB. When I shoot it, I'll subtract it and simultaneously add it to the round count. Easy-peasy. I've got all my ammo in ammo cans in my closet, so I can't do a quick look-see to determine what I've got and what I'm running low on.

    I don't reload, though.

    But, I do understand some folks just don't care about these things. :yawn:
     
Loading...
Similar Threads Forum Date
Excel spreadsheet Tech Talk Sep 7, 2015
Spreadsheet vs. database Tech Talk Jul 13, 2011
I need a Spreadsheet. Tech Talk Apr 18, 2011
test spreadsheet Test-Posts Here Jan 6, 2007
spreadsheet question Tech Talk Apr 6, 2005
Duty Gear at CopsPlus