Anybody have a good ammo inventory spreadsheet they want to share?
| Please Support Our Sponsors |
Anybody have a good ammo inventory spreadsheet they want to share?
Last edited by Raoul; 07-03-2009 at 07:19 PM.
Politics is the entertainment branch of industry.
I can make you one that is online. heck I can make eveyone one......LOL
What would you want on it?
I'm just looking for a way to keep to keep up with inventory by caliber.
So I guess the parameters would be caliber, brand, number of rounds, ability to add and subtract, etc.
Maybe a good looking redhead to enter the data and keep up with it?
But seriously, I bet you could sell one if you could put a form type front end on it.
Politics is the entertainment branch of industry.
Here is a little something I have. It's on PowerPoint so I think I would have to email it to anyone who wanted to try it.
Here is what it looks like, nothing pretty, but it gets the job done.
http://docs.google.com/Presentation?...k69_11dv2fj2gs
If anyone is interested shoot me a PM.
Edit: And the Total cell automatically takes the values from the On Hand, Expended, and Purchased cells and does all the math for you.
I've been increasing my stock lately so I was thinking of coming up with an Excel spreadsheet to help me keep track...but not being an excel pro, I know it will cost me some time to do, lol. If anyone already has one to share, I'd love to see it.
"A veteran, whether active duty or guard or reserve, is someone who, at one part in their life, wrote a blank check made payable to "The United States of America" for an amount up to and including their life."
I work with spread sheets daily. Excel for these purposes is very easy. An addition or subtraction formula is basiclly as simple as typing that function in the cell.
If you don't get what you need from the above guys just shoot me an email and I can generate one for you in about a minute.
I just made one the other day for an insurance quote and surprisingly I don't own 10,000 dollars worth of guns so I must buy more immediately!
Sent from my laptop, like usual.
Μολὼν λαβέ
"Stabil for your gas, but diesel is better. I plan on two gallons a day for myself only. That's bare minimum for drinking,"
Suntzu Aug 2010 SHTF thread....really, he said that.
I'm embarrassed by mine, not because of the volume of ammo, but because of the simplicity.
My columns:
Qty on hand
Qty on order
Caliber
Description, including mfg, bullet weight, etc.
Usage category for self-defense, target shooting, etc.
I run totals only for each caliber, then a grand total fed by the caliber totals....that's it. I update it after each range session and change the date in a description field at the top of the spreadsheet. The total on-hand should be within 100 rounds of accuracy.
Relative to this, I have created inventory tags on my ammo cans in order to check my totals at a glance. Keep seperate cans for each caliber to cover target and SD needs.
My YouTube Channel with shooting videos: tnoutdoors9