Tennessee Gun Owners - View Single Post

**tnoutdoors9** · 07-05-2009, 02:05 PM

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.

07-05-2009, 02:05 PM	#9 (permalink)
tnoutdoors9 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