Anyone inventory their ammo using Excel?....care to share your spreadsheet layout?

Not really very sophisticated, but it serves my purposes:



When entries are made in the shooting log the totals are updated (legibly for me) in the colored cells.

Doesn't anyone worry about records??

Nothing written down = nothing for admission in court....

At the rate I bought ammo this year my credit cards give me a system,when I run low I buy more and looking at the statements can see by month what calibers got shot and a rough count (percentage) remaining.If ya worry about lists for court it is too late,judging by news articles about lists of card numbers that get stolen and data bases accessed.
    You can also figure that government types can go get that info easily also.Best way is always cash to buy but not much of that around these days either it seems once the price doubled on most of it.
   I actually did snag an Excel sheet someone posted here and run it on a POS Goodwill old computer never connected to the internet that I keep the complete file on a thumbdrive as I update it.Got to figure sooner or later that I will forget what I do have left for ammo and is a good thing really as it also gives me a reference when I think something is on sale enuff to buy more of.

Quoted: Doesn't anyone worry about records?? Nothing written down = nothing for admission in court....

It's not illegal to own ammunition and there's already a paper trail from purchasing the stuff.

I have a simple one for my meager (by ArfCom standards) supply... all my ammo is in ammo cans, so first column is Can Number, followed by: Caliber, Manufacturer, Product Name, Grain, Projectile Type, Quantity, Date of final seal/dessicant (or marked as "open" if it is a can of 'short-term' ammo) and a small empty space for written/typed notes.  I keep lot numbers on my individual can labels, so I left them off the spreadsheet to save space.

Fits nicely on 4 pages, landscape format, Arial 10 font, extra line between each can.

I keep an electronic copy at home and at work, and a printed copy by the ammo fort on a clipboard so I can jot down changes.

Not worried about records.  As stated, not illegal for me to own, and since most was purchased with a credit card there is already a paper trail.  Hell... my "work" copy is kept on my gubmint computer.

Quoted: Quoted: Doesn't anyone worry about records?? Nothing written down = nothing for admission in court.... It's not illegal to own ammunition and there's already a paper trail from purchasing the stuff.

+1

Let's put on our tin foil hats for a second and say that they're watching.  If that's true and you buy your ammo with a debit or credit card then it's too late to be worrying about them hacking into your PC to check out your ammo spreadsheet.

Quoted: Not really very sophisticated, but it serves my purposes: i150.photobucket.com/albums/s95/MMcfpd/Ammo_on_hand.jpg When entries are made in the shooting log the totals are updated (legibly for me) in the colored cells.

Thanks, that gave us some good ideas to go off.