I've got all of my firearms in a backed-up Excel spreadsheet. Manufacturer, model, SN, multiple pictures etc. Ammo - no - I tried, but other than my backup stash in ammo cans, I cycle through it too much.
Do you just have columns for brand-model-caliber-serial number? That kind of thing?
I can do a little in Excel but I didn't know you could add pictures. Can you add thumbnails or do you just resize the pictures?
I can do a little in Excel but I didn't know you could add pictures. Can you add thumbnails or do you just resize the pictures?
Thanks. I can make one of those work easily.
If you don't mind I would like to look at it at least.If one doesn't work for you, let me know and I'll send you mine as a template. The pictures might be quite different though.
Sent from my iPhone using Tapatalk
I've never been one to keep a round count but a ammo inventory would be nice but keeping it current would be more work.Excel with detail info. A tab for shooting so I have a close round count per gun. Another tab for my ammo inventory which is close but not exact. Pictures with serial numbers are in a folder in Outlook but also in my work Outlook folder so if my personal laptop is stolen or the house burns, I've got a backup elsewhere.
Anything important I keep on my home computer is also backed up and kept on a thumb drive at my work location.
shortround;1533350 I have not figured out a way to subtract what I shoot said:You'll need a separate column for the round count. At the bottom of the column, or in any empty cell for that matter, click on a cell and type in =SUM(A1:A15) In this case, A is the column and 1 thru 15 are the rows to be summed. That will track the number of rounds on hand as you change the numbers in column A. I use a different worksheet for each caliber.
I have not figured out a way to subtract what I shoot, so I keep all my empty boxes and brass.