Do you spreadsheet your ammo? - Page 1

Site Notices

[ARCHIVED THREAD] - Do you spreadsheet your ammo? (Page 1 of 2)

Posted: 1/13/2021 7:42:26 PM EDT

That's what I did today. Decided to get an actual ammo count.

I was surprised to learn my ammo count total. I am also surprised to find out that almost exactly half of that total is rimfire.

Posted: 1/13/2021 7:49:30 PM EDT

[#1]

Quoted:
That's what I did today. Decided to get an actual ammo count.

I was surprised to learn my ammo count total. I am also surprised to find out that almost exactly half of that total is rimfire.

View Quote

i just take a picture of my ammo safe

Posted: 1/13/2021 7:52:02 PM EDT

[#2]

Yes, I do.

Posted: 1/13/2021 7:53:16 PM EDT

[#3]

Yes

But I spreadsheet all the things.

Posted: 1/13/2021 7:54:46 PM EDT

[#4]

Yep, and I sold probably 15K rounds in the last few months. That and a couple guns totaled out at $17K or so. I'm a beancounter, so I have a spreadsheet that tracks the blades of grass in my lawn.

Posted: 1/13/2021 7:58:55 PM EDT

[#5]

I got 5 rounds of .300blk but one of them is a range pickup so I put that one on a different page.

cant be too careful.

Posted: 1/13/2021 8:00:01 PM EDT

[#6]

Hell no . Aint nobody got time for that .

Have a general idea

Posted: 1/13/2021 8:00:18 PM EDT

[#7]

Of course

Posted: 1/13/2021 8:01:07 PM EDT

[#8]

Fuck no

Posted: 1/13/2021 8:01:20 PM EDT

[#9]

Sometimes I spread shoot it

Posted: 1/13/2021 8:01:24 PM EDT

[#10]

No. But I pretty much know.

Posted: 1/13/2021 8:02:21 PM EDT

[#11]

Wait, people don’t?

Edit: everyone should spreadsheet, track by caliber and maybe purpose (defensive, training etc) and then color code based on how you should prioritize next purchases.

Posted: 1/13/2021 8:02:39 PM EDT

[#12]

The last time I tried, I tried to do it by weight. That was like 3 years ago.

Posted: 1/13/2021 8:03:48 PM EDT

[#13]

Used to, then I sold my mini-14

Posted: 1/13/2021 8:04:06 PM EDT

[#14]

Yes, plus I weigh it, so I know how much I can move in each car.

Posted: 1/13/2021 8:04:19 PM EDT

[#15]

I didn't think anyone could be this anal.

Posted: 1/13/2021 8:04:36 PM EDT

[#16]

Quote History

Quoted:
Yes

But I spreadsheet all the things.

View Quote

Posted: 1/13/2021 8:04:42 PM EDT

[#17]

Shakes box....

Yes, I have ammo.

Posted: 1/13/2021 8:06:14 PM EDT

[#18]

I've got more defensive 9mm (Mainly Federal Tactical Hydra-shock 124 +P+) I do recall seeing a hell of a closeout price long ago and stocking up. I know it's not the 'newest most badass shit on the planet'. I woudn't mind trading on for target 9mm. Wondering if 50 rounds defensive is equal to two boxes target or 3 boxes.

Posted: 1/13/2021 8:06:26 PM EDT

[#19]

What ammo?

Posted: 1/13/2021 8:07:18 PM EDT

[#20]

Ha. Yes I do also
Ammo and dates, serial numbers, shooting and reload data, etc

Posted: 1/13/2021 8:08:38 PM EDT

[#21]

I shoot too often. If I bothered to spend a day counting it all, I would never be able to keep it updated.

I just know that I shouldn't have any empty ammo cans.

Posted: 1/13/2021 8:12:32 PM EDT

[#22]

Haha. No. I find stuff I forgot about and it makes my day. I tried keeping a round count/ log of a couple rifles and that lasted 1 or 2 times max.

Posted: 1/13/2021 8:13:51 PM EDT

[#23]

If I had more I might but I can carry what I have.

Posted: 1/13/2021 8:15:17 PM EDT

[#24]

Nope. My wife counts it and uses peanut butter to write the total on my forehead.

Posted: 1/13/2021 8:15:47 PM EDT

[#25]

Track muy mags and round cutn :)

Posted: 1/13/2021 8:20:02 PM EDT

[#26]

I just have it all in ammo cans under my pool table.

Posted: 1/13/2021 8:25:18 PM EDT

[#27]

Used to, but not since I sold all my guns and ammo. It was a handy tool, but I couldn’t pass up the $$$ I was offered for everything.

Posted: 1/13/2021 8:37:26 PM EDT

[#28]

Did you know you can judge a man's ammo stockpile if he tells you he spreadsheets?
See...
If you have an amatuer stockpile, you don't bother to spreadsheet because you can remember what you have in a few ammo cans.
If you have a respectable stockpile, you spreadsheet because critical levels and inventory matters.
If you have a bow down, full tilt boog stockpile, you no longer spreadsheet since you never have to worry about critical levels.

Posted: 1/13/2021 8:40:05 PM EDT

[#29]

Been using a spreadsheet for this stuff for years.
Because my thinker doesn't remember details that well.

Posted: 1/13/2021 8:41:24 PM EDT

[#30]

Yep.......with a pen and a pad.

Posted: 1/13/2021 8:42:36 PM EDT

[#31]

You gotta pivot table that shit!

Posted: 1/13/2021 8:42:38 PM EDT

[#32]

I got a sweet pivot table and everything

edit: poster above me knows what's up

Posted: 1/13/2021 8:51:01 PM EDT

[#33]

I don't do a spread sheet, I just write it on a legal pad. I think the outcome is the same.

Posted: 1/13/2021 8:52:24 PM EDT

[#34]

No.

Posted: 1/13/2021 8:56:08 PM EDT

[#35]

Nope.

The only spreadsheet I maintain right now is my calorie counter to make sure I'm hitting the # I want.

Posted: 1/13/2021 9:07:26 PM EDT

[#36]

It’s in ammo cans, I want a surprise when I open them up. I bought slugs and OO for a 3 gun match years ago when ammo was cheap for a buddy and he wasn’t able to make it. Saw it the other day.

Posted: 1/13/2021 9:10:00 PM EDT

[#37]

Pics of spreadsheet ?

Posted: 1/13/2021 9:18:47 PM EDT

[#38]

No, I'm not that anal or that bored.

I don't sort my socks by color either.

Posted: 1/13/2021 9:19:51 PM EDT

[#39]

I'm pretty OCD, but even I have my limits. I measure my ammo in terms of cans. 50 cal cans. If you need a spreadsheet, you either have a lot less or a lot more than I do.

Posted: 1/13/2021 9:20:06 PM EDT

[#40]

Yes, 20% is rimfire. Over 10K of them.

Posted: 1/13/2021 9:21:49 PM EDT

[#41]

Yes , I also have it with a formula to go red when it gets below certain levels. Not that I can do anything about that right now though.

Posted: 1/13/2021 9:22:48 PM EDT

[#42]

Ran out of rows.

Posted: 1/13/2021 9:24:25 PM EDT

[#43]

Why yes, yes I do

Posted: 1/13/2021 9:25:26 PM EDT

[#44]

Quote History

Quoted:
No, I'm not that anal or that bored.

I don't sort my socks by color either.

View Quote

I'll raise you.

I have dozens of pair of socks, but only three types - black cotton crew, white cotton crew, and white cotton low...and all the pairs in each set are identical and purchased on the same day. They each get their own drawer. I haven't folded a pair of socks or been knowledgeable of a lost sock in years. And they wear out at the same rate since I grab two randomly from a set. When I notice a sock seems to be getting old, I quickly confirm several others in that set are in the same shape and then dump the entire set, replacing them with another dozen.

I will never understand why anyone wants to spend time matching unique socks. Holy hell, they go on your feet. They need to be comfortable, not fashionable.

Posted: 1/13/2021 9:25:51 PM EDT

[#45]

Quote History

Quoted:
Hell no . Aint nobody got time for that .

Have a general idea

View Quote

Yeah especially when I dump the majority of my ammo into 30 or 50 cal ammo cans.

Posted: 1/13/2021 9:27:32 PM EDT

[#46]

Quote History

Quoted:
Pics of spreadsheet ?

View Quote

It's pretty simple

I've got the following categories

Caliber (really chambering of course or gauge)
Count(number of boxes)
Size (amount in each box)
Type (grain and type of bullet - for shotgun ammo I did "birdshot" rather than individual number, but did do 00B -15p 00B-12p and 4B )
Detail (manufacturer name and details - be it WWB or Horn Crit Def. )

I have it programmed to do count x size to give me the ammo count in the next column. I then sum up all the ammo by caliber

Any partial boxes of 50 or less get moved to the range bag. For the stuff in bulk 1000 boxes, I'll have one of those out of the box just in the plastic bag, and I'll estimate that. So while I might have caliber 9mm count 3 size 1000 type 115 FMJ Detail bulk, but I'll also have caliber 9mm count size 200 type 115 FMJ Detail - Bulkbag

Posted: 1/13/2021 9:29:00 PM EDT

[#47]

I just count how many rows I have left before I reach the pallet.

Posted: 1/13/2021 9:30:38 PM EDT

[#48]

lol, no.

Posted: 1/13/2021 9:32:35 PM EDT

[#49]

When the panic hit and prices went up I did do a total round count.

Didn't do a spread sheet but did need pen and paper to tally.

Posted: 1/13/2021 9:43:05 PM EDT

[#50]

Quote History

Quoted:
It's pretty simple

I've got the following categories

Caliber (really chambering of course or gauge)
Count(number of boxes)
Size (amount in each box)
Type (grain and type of bullet - for shotgun ammo I did "birdshot" rather than individual number, but did do 00B -15p 00B-12p and 4B )
Detail (manufacturer name and details - be it WWB or Horn Crit Def. )

I have it programmed to do count x size to give me the ammo count in the next column. I then sum up all the ammo by caliber

Any partial boxes of 50 or less get moved to the range bag. For the stuff in bulk 1000 boxes, I'll have one of those out of the box just in the plastic bag, and I'll estimate that. So while I might have caliber 9mm count 3 size 1000 type 115 FMJ Detail bulk, but I'll also have caliber 9mm count size 200 type 115 FMJ Detail - Bulkbag

View Quote

I store it in cans labeled a bit more granularly, noting caliber, grain, and type...typically FMJ or JHP. If I have a lot of one type and think I'll restock in that type, like mini mags, then the can may get labeled that way. Otherwise, it's generic. I generally know what fits in a can for each cartridge type, so I can do the math in my head for any one caliber fairly quickly. I have magnetic labels on the front, or shifted to the top if they are in the back row, and I don't stack the cans, so it's pretty easy to get a quick count of a caliber.

[ARCHIVED THREAD] - Do you spreadsheet your ammo? (Page 1 of 2)

General » General Discussion

Warning

Confirm Action

About AR15.COM

Stay Connected

Newsletter

Contact Us