Ammo inventory

[GunnyGene]

What to do when boredom sets in :roll: . Create a Ammo Inventory Spreadsheet. :lol: Wasted about 2 hours yesterday creating a spreadsheet and inventorying ammo, mainly just to have something to do. Automatically subtotals each category and gives a Grand Total. Didn't bother with additional columns for cost, etc. :wink:

 

[WIL TERRY]

IS it not easier to just look in the ammunition cabinet to see how much there is ??

And so it goes...

 

[contender]

Hey,,, he said he was bored!
And if he only has a small amount,,, it'd be easier. But a few of us happen to have a little more,,, so it's take longer to do a spreadsheet.

 

[NikA]

I did that too once, but once I started reloading, all was lost. Now I just try to keep the database with serial numbers up to date for insurance purposes.

 

[Jimbo357mag]

I've got cases primed and waiting to be reloaded in the garage but it has been just too dang hot to work on them, going on several weeks now. I'm glad I made plenty of ammo when it was cooler.

 

[Twoboxer]

That's hilarious, Gunny . . . I already had a spreadsheet for components and ammo . . . so when I got bored last week I converted it to an Access database.

(BTW, it was better as a spreadhseet lol).

 

[gunzo]

I don't consider it time wasted. I would have been way ahead, time & concern wise if I had developed a good inventory record system about 8 years ago this coming Nov.. I counted up everything then, but had to keep doing it over & reprojecting my usage every time there was another event that started more or different shortages. I failed, failed to foresee that it would go on as long as it has.

 

[Rumrunner]

I just did an inventory of the ammo I'm taking prairie dog shooting next week. 340 rounds of 22-250; 1450 rounds of 223; and 1000 rounds of 17 HMR. Haven't decided if I will take my 10/22 or American 22 yet.

 

[Mobuck]

I would have to hire help.

 

[Ka6otm]

I keep an inventory of my reloading components and magazines in my SmartPhone so when I stumble across a really good deal, I can whip out the inventory and see if I need that particular thing.

It works very well.

 

[Mobuck]

"when I stumble across a really good deal,"

I buy it anyway regardless of how much I already have.

 

[tsubaki]

Tried it once, well after giving up attempted it a second time.
Now I'm deeper in the hole.

 

[SweetWilliam]

I have a note book with every loaded cartridge from 22 rimfire to 375Ruger. Shotgun included. Plus empty brass, unloaded bullets, primers, powders.
You gotta know what you have. Lol

 

[pruger45]

I open the ammo closet and look!

 

[Johnnu2]

I use a spreadsheet to catalog the various powders I have against the calibers I can use each powder for. I list the powders down the left col. and the calibers across the top; then put a "Y" in the appropriate cells. If you are extra anal like me, you can also put the calibers down the left col of a separate sheet and the powders across the top. This way you can quickly look up your info either by cal or by powder on two sheets...... YUP, I'm retired. J

 

[WIL TERRY]

I open the ammo closet and look!

BINGO...WE HAVE A WINNER !!!!
And so it goes...

 

[George]

Inventory spread sheet? I did try that but could not keep it updated and then started reloading now every thing is just lost! LOL!!! Heck Got mine in military ammo cans one large 20mm can a crap load of the regular sized ones and another crap load of the small ones yep labeled heck tried to fill them by caliber cant do that I can't even find what the heck I want even though I can see in my mind how there loaded.. Wish I had a better system! There's got to be a better way. No bunker no garage.. I think I need help. George

 

[Ka6otm]

I open the ammo closet and look!

BINGO...WE HAVE A WINNER !!!!
And so it goes...

I've got way too much to be able to do that in less than an hour or so.

Thus, the inventory on my PC and my Smartphone.

 

[DGW1949]

I don't use but a few calibers of ammo and what I use is all stored in old ammo cans,each of which hold X-amount of given caliber....so mostly, "taking inventory" is merely a matter of looking at labels, counting how many cans I have of each, and then doing a bit of simple math in my head.
Other than that, once a can is opened, all of the boxes from that particular can get transferred to the "using shelf", the can itself get's turned around so the label don't show, and that particular can doesn't get counted again until it's re-filled with new "stock" and turned so's the label shows again.
As for the boxes on the shelf, I don't even bother about "how many". Reason is, it's perty-easy to know from a glance when it's getting close to time for opening another can.

But that's just me, I like keeping things simple.

DGW

 

[Srb08]

I use a spreadsheet to catalog the various powders I have against the calibers I can use each powder for. I list the powders down the left col. and the calibers across the top; then put a "Y" in the appropriate cells. If you are extra anal like me, you can also put the calibers down the left col of a separate sheet and the powders across the top. This way you can quickly look up your info either by cal or by powder on two sheets...... YUP, I'm retired. J

I do the same but but also list bullets for some of the cartridges. The preferred powder for the bullet gets a * by the X.
I can only imagine how detailed I'll get, when I retire.

 

[gramps]

Wow! Goofing off 8) , mowing, AM hikes, Fire Dept, Classes to maintain medical licenses takes up all my time. Oh yeah I work 3-4 days a week.
gramps, who is supposed to be retired :shock:

 

[powder smoke]

I open the ammo closet and look!

Wish it was that easy, Got 50cal. ammo cans 22 at last count, do have labels but not up to date.
Rummage thru sometimes to find what I want lol. Organization is not my strong suit. ps

 

[K. Funk]

I would take me many hours just to dig out some of my past ammo purchases in order to count them. I got stuff buried under all kinds of other stuff. Ain't gonna happen!!

krf

 

[Srb08]

I have an inventory of guns, ammo, components, magazines, holsters and parts, that's pretty up to date. I know what I have, I just don't always know where it is.