 |
|
|
|
|||||||
| Ammunition and Reloading Discussion of topics related to factory loaded ammunition and to the art of reloading your own ammunition. |
 |
|
|
LinkBack | Thread Tools | Display Modes |
07-03-2009, 08:16 PM
|
#1 (permalink) |
|
TGO Member
 Joined: Mar 2009
Where: Tri-Cities
Age: 54
Posts: 365
|
Ammo inventory spreadsheet
Anybody have a good ammo inventory spreadsheet they want to share?
__________________
“Life is a near death experience.” Dr. John Last edited by Raoul; 07-03-2009 at 08:19 PM.. |
|
      
|
|
07-04-2009, 10:00 AM
|
#3 (permalink) |
|
TGO Member
Joined: Mar 2009
Where: Tri-Cities
Age: 54
Posts: 365
|
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.
__________________
“Life is a near death experience.” Dr. John |
|
|
|
|
07-04-2009, 11:00 AM
|
#4 (permalink) |
|
Nobody Special
Joined: Sep 2007
Where: Wonju, South Korea
Age: 25
Posts: 523
|
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.
__________________
People sleep peaceably in their beds at night only because rough men stand ready to do violence on their behalf. - George Orwell Last edited by JustAGuy; 07-04-2009 at 11:03 AM.. |
|
|
|
07-04-2009, 11:08 AM
|
#7 (permalink) |
|
TGO Member
Joined: Jan 2009
Where: Goodlettsville
Posts: 153
|
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." |
|
|
|
|
07-04-2009, 01:26 PM
|
#8 (permalink) |
|
What? No Pancakes?
Joined: Jul 2007
Where: Westmoreland, TN
Age: 46
Posts: 2,283
|
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!
__________________
Μολὼν λαβέ Riddled with BRD NRA Life Member |
|
|
|
|
07-05-2009, 02:05 PM
|
#9 (permalink) |
|
TGO Freshman
Joined: Jun 2009
Where: Mt. Juliet TN
Age: 48
Posts: 44
|
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 |
|
|
|
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
