Personnal Ammo Inventory - Anyone gots any Excel/Access tools for this?

This is a discussion on Personnal Ammo Inventory - Anyone gots any Excel/Access tools for this? within the Off Topic & Humor Discussion forums, part of the The Back Porch category; You'nze! I decided to spend the next couple of days pulling ammo out of the cupboards and assorted other stash locations and taking a serious ...

Page 1 of 2 12 LastLast
Results 1 to 15 of 16
Like Tree3Likes

Thread: Personnal Ammo Inventory - Anyone gots any Excel/Access tools for this?

  1. #1
    VIP Member
    Array ANGLICO's Avatar
    Join Date
    Mar 2012
    Location
    I'm the guy next door that is polite, but does not tell you crap.
    Posts
    3,166

    Personnal Ammo Inventory - Anyone gots any Excel/Access tools for this?

    You'nze! I decided to spend the next couple of days pulling ammo out of the cupboards and assorted other stash locations and taking a serious inventory. Really have lost track of how much of which caliber I own..... LOL Heck, I've lost track of how much I own or go through on range day.

    These days, I kind of look in one vault and if the pile of boxes is below 18 inches high, it's time to buy!

    Any of you have an .xls file template or a good MS Access database that I can use to record my inventory? I could build one, but I'd really like to see what is already out there.

    I'd also like it to be able to point to where it is, since I store in several locations.

    Thanks in advance!

    Semper Fi,
    Socialism Kills! Time proven, with a very large body count! We are a Constitutional Republic....... not a Democracy, get it correct!

    Don't be mistaken for a Gecko45: http://lonelymachines.org/mall-ninjas/

    Watch: http://www.youtube.com/watch?v=14qTdp-Dd30

    ANGLICO Images

  2. Remove Ads

  3. #2
    Senior Member
    Array whoppo's Avatar
    Join Date
    Mar 2012
    Location
    Southern Maine
    Posts
    1,174
    Maybe it's the aluminum leeching from the foil hat into my (alleged) brain, but I prefer to NOT document my ammo supplies ;)
    I simply earmark 200-300 a month for "supplies" to replace what we shoot at the range... Seems to work well enough to maintain a usable inventory.
    Sky Pilot likes this.
    ----------------------------------------------------------
    The Second Amendment *IS* Homeland Security
    ----------------------------------------------------------
    --------------------- Μολὼν λαβέ ----------------------
    ----------------------------------------------------------

  4. #3
    Distinguished Member Array sid1's Avatar
    Join Date
    Feb 2012
    Location
    Wisconsin
    Posts
    1,886
    Ive been using one thats been compiled from a few so it has three pages one for your guns one, for ammo inventory, and one for ammo details. Pm me your email and I will me happy to email it to you and see if it's what your looking for?

  5. #4
    VIP Member
    Array ANGLICO's Avatar
    Join Date
    Mar 2012
    Location
    I'm the guy next door that is polite, but does not tell you crap.
    Posts
    3,166
    Quote Originally Posted by whoppo View Post
    Maybe it's the aluminum leeching from the foil hat into my (alleged) brain, but I prefer to NOT document my ammo supplies ;)
    I simply earmark 200-300 a month for "supplies" to replace what we shoot at the range... Seems to work well enough to maintain a usable inventory.
    I get your point. I'll use the Mission Impossible Reel type tape to record it on, just in case!

    Anyway, I need to start an inventory because I tend to have ammo for calibers I don't own as well, and when going to the range I often spot my friends, and want to make sure that we are all in sync on what is what, as well as keep enough for when the SHTF.

    You can have all the Gold and Silver in the world, but without ammo and something to bang the ammo down range, you aint keeping it!

    Society is not so Civil after 3 days without power, water and LEO.
    Socialism Kills! Time proven, with a very large body count! We are a Constitutional Republic....... not a Democracy, get it correct!

    Don't be mistaken for a Gecko45: http://lonelymachines.org/mall-ninjas/

    Watch: http://www.youtube.com/watch?v=14qTdp-Dd30

    ANGLICO Images

  6. #5
    VIP Member
    Array ANGLICO's Avatar
    Join Date
    Mar 2012
    Location
    I'm the guy next door that is polite, but does not tell you crap.
    Posts
    3,166
    @ skid1

    Thank you for offering Sir.

    Sent you a PM.

    Semper Fi!
    sid1 likes this.
    Socialism Kills! Time proven, with a very large body count! We are a Constitutional Republic....... not a Democracy, get it correct!

    Don't be mistaken for a Gecko45: http://lonelymachines.org/mall-ninjas/

    Watch: http://www.youtube.com/watch?v=14qTdp-Dd30

    ANGLICO Images

  7. #6
    Member Array thedogfather's Avatar
    Join Date
    Jun 2009
    Location
    Western Washington
    Posts
    311
    'Files, template, database' ... holy cow, ... I keep my inventory hand written in a note book that I update every now and then. I add a couple of that, I subtract a couple of this. Every three months or so, I take every thing out and count box and round to get an accurate count. This also give me an excuse to have 'hands on' time with my guns ... wipe the slide, rack the chamber, work the bolt, eject the speed loaders and magazines , wipe everything down and reload ... what do I buy next payday? Ok, that is me. I'm an old dog. I bark, but I definitely bite.

  8. #7
    VIP Member Array nedrgr21's Avatar
    Join Date
    Jun 2008
    Location
    KCMO
    Posts
    3,107
    As to "not keeping an inventory", there are many, many ways to hide such info electronically - no one else ever need find out.

  9. #8
    Senior Member Array 45ACP4ever's Avatar
    Join Date
    Mar 2006
    Location
    Wisconsin
    Posts
    653
    Hiding your inventory? Really? You own firearms and you are on a firearms website (and probably not just this one) and you are worried about the government "getting you" for keeping an inventory?

    If you really are super scared that the government is going to get you because of your ammo, do the notebook thing.

    I don't mean to come across as rude, but...reality check.
    "It is your evil that will be sought by us. With every breath we will hunt them down. Each day we will spill their blood, until it rains down from the skies. Do not kill. Do not rape. Do not steal. These are principles that every man from every faith can embrace." -McManus twins Boondock Saints

  10. #9
    Senior Member Array Bubbiesdad's Avatar
    Join Date
    Dec 2009
    Location
    East TN
    Posts
    1,014
    I just use simple microsoft word. When I go to the range, I subtract the ammo I take with me. If I bring any home, I add it back to the total.
    Once the initial count is done, you can easily keep track of your inventory.
    Always remember that others may hate you but those who hate you don't win unless you hate them. And then you destroy yourself.
    Richard M Nixon
    Owning a handgun doesn't make you armed any more than owning a guitar makes you a musician.
    Jeff Cooper

  11. #10
    VIP Member
    Array ANGLICO's Avatar
    Join Date
    Mar 2012
    Location
    I'm the guy next door that is polite, but does not tell you crap.
    Posts
    3,166
    Thank you for the help everyone. Got what I need. Simple. Now what I need is a personsal administrative assistant..... LOL

    Semper Fi,
    Socialism Kills! Time proven, with a very large body count! We are a Constitutional Republic....... not a Democracy, get it correct!

    Don't be mistaken for a Gecko45: http://lonelymachines.org/mall-ninjas/

    Watch: http://www.youtube.com/watch?v=14qTdp-Dd30

    ANGLICO Images

  12. #11
    Senior Member
    Array whoppo's Avatar
    Join Date
    Mar 2012
    Location
    Southern Maine
    Posts
    1,174
    Aluminum foil jokes aside, I've just never had a reason to calculate / record / document / alphabetize ammunition supplies.
    When the stacks in the ammo locker start looking low, I order more.
    When it's time to rotate stock in the "stored for special purposes" ammo containers, I order matching replacements and put the older stuff in the range piles.
    Between handguns, rifles and shotguns I've only got 8 different calibers/GA's to worry about, so for me it's not really worth the effort to document any of it.
    ----------------------------------------------------------
    The Second Amendment *IS* Homeland Security
    ----------------------------------------------------------
    --------------------- Μολὼν λαβέ ----------------------
    ----------------------------------------------------------

  13. #12
    Ex Member Array Ram Rod's Avatar
    Join Date
    Dec 2007
    Location
    Fayetteville, AR
    Posts
    13,687
    You know......I've personally tried over the numerous years to keep track of/inventory my ammo in various ways. I can honestly say there's no sure ways of labeling, storing, putting it all on paper sure way. You can get close and do it all over again. These days....I just feel comfortable knowing some of my stash can't be calculated. I figure it's best I don't know in ways. Each time I expend some of my stash....I try to replenish it and over-estimate......this is a good thing in my opinion. That way I always end up with more than I spent at the range. Make sense now?

  14. #13
    VIP Member
    Array atctimmy's Avatar
    Join Date
    Jan 2008
    Location
    NSA Headquarters
    Posts
    6,243
    I inventory my ammo with my standard issue M1, Mod Zero eyeball.
    Two roads diverged in a wood, and I
    I took the one less traveled by,
    And that has made all the difference.

  15. #14
    VIP Member
    Array blitzburgh's Avatar
    Join Date
    May 2012
    Location
    Coastal SC
    Posts
    3,737
    My method is I started with 10k rounds and each time I go below that number, I buy twice the amount I used. At least I know I'll never go below 10k, which makes me quite a happy camper.
    "Rebellion against tyrants is obedience to God." - Benjamin Franklin

    "Experience: that most brutal of teachers. But you learn, my God do you learn." - C.S. Lewis

  16. #15
    Distinguished Member Array Brady's Avatar
    Join Date
    May 2008
    Location
    South Carolina
    Posts
    1,380
    I just use a straight excel data sheet. One page each for handgun, rifle, shotgun ammo. Do the math manually and use the data/sort functions. The same for firearms inventory, tax papers and other assorted important documentation. keep the data on a couple, 2 or 3 thumb-drives in different locations in case of computer crash, theft or fire.
    ...he that hath no sword, let him sell his garment, and buy one. Luke 22:36
    USN/VET; NRA; GOA, jpfo.org
    Life in a Jar: The Irena Sendler Project www.irenasendler.com

Page 1 of 2 12 LastLast

Links

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Search tags for this page

ammo inventory excel

,
ammo inventory form
,

ammo inventory sheet

,

ammo inventory spreadsheet

,

ammo inventory template

,

ammunition inventory excel

,

ammunition inventory form

,

ammunition inventory spreadsheet

,
gun inventory sheet
,

gun inventory spreadsheet

,
microsoft access ammo inventory
,
printable ammo inventory form sheet
Click on a term to search for related topics.