Survivalist Forum

Advertise Here

Go Back   Survivalist Forum > Firearms and Other Weapons Forum > Firearms General Discussion
Articles Chat Room Classifieds Donations Gallery Groups Links Store Survival Files



Firearms General Discussion Rifles, pistols, shotguns, scopes, grips and everything in between.

Advertise Here
Reply
 
Thread Tools Display Modes
Old 01-25-2013, 10:05 PM
BugOutBicycle's Avatar
BugOutBicycle BugOutBicycle is offline
Knowledge Hoarder
 
Join Date: Sep 2012
Location: On my way ...
Posts: 281
Thanks: 887
Thanked 313 Times in 137 Posts
Default Ammo Inventory Spreadsheet Template?



Advertise Here

Planning on doing some ammo inventory check this weekend and was thinking about using an excel spreadsheet.

Anyone else is keeping exact track of your ammo inventory?

Any templates available?

Thanks.
Old 01-25-2013, 11:26 PM
Ryan316's Avatar
Ryan316 Ryan316 is offline
Living it up while I can
 
Join Date: Nov 2008
Location: New Orleans, LA
Posts: 123
Thanks: 648
Thanked 38 Times in 25 Posts
Default

I did it. No templates I know of. I just did it the old fashioned way. Had more than I thought.
The Following User Says Thank You to Ryan316 For This Useful Post:
Old 01-26-2013, 07:02 AM
meadmkr's Avatar
meadmkr meadmkr is offline
Nothing to see here...
 
Join Date: May 2009
Location: No.VA
Posts: 556
Thanks: 1,337
Thanked 395 Times in 248 Posts
Default

I inventory it by weight and have a rough estimate of rounds/per pound and mark it on the ammo can its stored in... The only list it goes on would be the shopping list if I'm running low on a specific caliber. And running low is a subjective term
Old 01-26-2013, 07:23 AM
BJJ_Grappler's Avatar
BJJ_Grappler BJJ_Grappler is offline
Allergic to Bull****
 
Join Date: Dec 2008
Location: FL
Posts: 10,741
Thanks: 10,567
Thanked 15,397 Times in 5,453 Posts
Default

Here is an example of how I keep track of my own. Columns left to right: Ammo can #, quantity of rounds, # of ammo boxes, brand name, model of ammo, caliber/gauge, type of bullet/slug/shot, grains, oz, DRAM, length, velocity, power, where they are stored, notes, and totals.


When I did it, I had less than I thought, but still more than I probably would ever need. It's good to know especially when you keep detailed lists like I do.
Attached Thumbnails
ammo-layout.jpg  
The Following User Says Thank You to BJJ_Grappler For This Useful Post:
Old 01-26-2013, 07:34 AM
dothedew's Avatar
dothedew dothedew is offline
Junior Member
 
Join Date: Feb 2010
Location: In the South
Posts: 167
Thanks: 46
Thanked 121 Times in 50 Posts
Default

Try this and see if it's what you're talking about http://www.riquiscott.com/publicdown...mmunition.xlsx
The Following User Says Thank You to dothedew For This Useful Post:
Old 01-26-2013, 07:42 AM
paddysdaddy's Avatar
paddysdaddy paddysdaddy is offline
cannin' apricots
 
Join Date: Nov 2011
Posts: 567
Thanks: 97
Thanked 763 Times in 304 Posts
Default

I stack mine vertically in 50 cal ammo cans by caliber. Minimum goal is that each stack exceeds the height of a rifle, not a carbine.
The Following User Says Thank You to paddysdaddy For This Useful Post:
Old 01-26-2013, 07:45 AM
ManyFeathers's Avatar
ManyFeathers ManyFeathers is offline
My Dixie Wrecked
 
Join Date: Sep 2010
Location: Republic of Texas
Age: 56
Posts: 6,322
Thanks: 7,866
Thanked 16,889 Times in 4,729 Posts
Default

It's relatively simple to set up a spread sheet on Excel.

Set your functions to add and calulate weight by each cartridge and then by multiples.

I would set the cartridge type on the top row and then have columns to the right for weight. Bottom row for totals

Column on the right margin for manufacture

So simple.....a caveman could do it
The Following User Says Thank You to ManyFeathers For This Useful Post:
Old 01-26-2013, 09:49 AM
Rascals's Avatar
Rascals Rascals is offline
Never Give up
 
Join Date: Dec 2008
Location: Portland Or
Posts: 6,979
Thanks: 9,941
Thanked 12,423 Times in 4,029 Posts
Default

You either have enought or you dont.
The Following User Says Thank You to Rascals For This Useful Post:
Old 01-26-2013, 10:02 AM
Catherine_MT Catherine_MT is offline
Survivor
 
Join Date: Mar 2012
Posts: 2,266
Thanks: 10,936
Thanked 3,134 Times in 1,492 Posts
Default

Hello,

I do it the old fashioned way and keep a loose leaf with information in it regarding reloading supplies, 22lr ammunition (His and hers.) and a bit of factory loaded ammunition listed too.

I find that writing it down on lined paper is easier for me when my hand arthritis is bad.

Plus I help my husband keep his things up to date too.

I did the same thing for my late husband even though we never had the time to get into reloading as we had planned.

I personally do NOT reload but my husband has for about 40 years.

If you shoot often, compete, practice your self defense shooting on a regular basis, have a few shooting events for your close friends at your range, plink and/or hunt... I think that it is wise to get into simple reloading.

I think that it is wise to keep your firearms and all supplies up to date on a regular basis and rotate your stock whether you shoot a bit or a lot of centerfire or rimfire caliber firearms.

Catherine
The Following User Says Thank You to Catherine_MT For This Useful Post:
Old 01-26-2013, 08:52 PM
BugOutBicycle's Avatar
BugOutBicycle BugOutBicycle is offline
Knowledge Hoarder
 
Join Date: Sep 2012
Location: On my way ...
Posts: 281
Thanks: 887
Thanked 313 Times in 137 Posts
Default

Thanks guys for the ideas.

Half way there. Got some more .50 ammo cans so I spent most of the time organizing everything.

BTW I though that I was very low on .22 but counted over 20K rounds and most of it is CCI MiniMag so I feel little better about it.

Still not where I want to be, but its a start
The Following User Says Thank You to BugOutBicycle For This Useful Post:
Reply

Bookmarks



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Looking for Excel spreadsheet for food storage inventory trilady66 Food and water 8 12-09-2012 07:53 AM
Ammo stockpile and inventory Festes Firearms General Discussion 29 12-02-2011 12:11 PM
What kind of pistol ammo do you inventory? BROWN FOOT Firearms General Discussion 43 11-29-2011 09:33 PM
Have your ammo inventory targets changed? Levant Firearms General Discussion 14 04-27-2009 10:50 PM


All times are GMT -5. The time now is 03:54 AM.


Powered by vBulletin®
Copyright ©2000 - 2014, vBulletin Solutions, Inc.
vBulletin Optimisation provided by vB Optimise (Pro) - vBulletin Mods & Addons Copyright © 2014 DragonByte Technologies Ltd.
Copyright Kevin Felts 2006 - 2012,
Green theme by http://www.themesbydesign.net