Firearm Spreadsheet [Archive] - Glock Talk

PDA

View Full Version : Firearm Spreadsheet


Hines57
07-04-2012, 02:27
I know they have been posted here before, but I can't find one. Anybody have an inventory spreadsheet they can share? Preferably one that includes photos.

Thanks

LabTech
07-04-2012, 11:26
Tagged.

racer88
07-04-2012, 11:28
I'm using MyGunDB and like it fairly well. A few features I'd like see added (ammo inventory). But, for most people, it's a great way to keep track of firearms and related info.

http://mygundb.com/

Hines57
07-04-2012, 21:03
That looks cool, maybe a bit more then I am really looking for. Would like to find a free one.

bac1023
07-04-2012, 21:09
I just use Excel and build the spreadsheets myself.

It works great.

unit 900
07-04-2012, 21:36
A little Google time and study recommends this one pretty highly:

http://www.nmcollector.net/nmguncollector/downloads/Free/index.htm

Looks like pics are easily included.

Quiet
07-05-2012, 01:54
BATFE Personal Firearms Record (http://www.atf.gov/publications/download/p/atf-p-3312-8.pdf)

Keep this list separate from your firearms to assist police in the event your firearms are ever lost or stolen.

oily_oink
07-05-2012, 07:59
BATFE Personal Firearms Record (http://www.atf.gov/publications/download/p/atf-p-3312-8.pdf)


Thanks for the Link! :wavey:

M2 Carbine
07-05-2012, 08:09
I just use Excel and build the spreadsheets myself.

+1

You can make it as simple or as detailed as you want.

racer88
07-05-2012, 08:18
I just use Excel and build the spreadsheets myself.

It works great.

#1
You can make it as simple or as detailed as you want.

Just me... but $40 is a bargain for a really cool program... and it saves me a LOT of time (trying to set up a good spreadsheet).

http://mygundb.com/

Free updates, and he updates it a LOT (plus he's very receptive to suggestions for new features. I just updated mine last night, and it appears he has added a good ammo inventory feature! I haven't explored it, yet, though.

MyGunDB is very comprehensive. Photos, purchase records, ammo usage and count, accessories for each gun, maintenance records, etc., etc. Check it out! (I have no financial interest or any connections to this company other than being a customer.)

Why make it difficult on yourself or time consuming? I don't have time to reinvent the wheel. $40 via paypal, and I'm off to the races!

fnfalman
07-05-2012, 08:26
I had a spreadsheet that lists the guns by manufacturers, model numbers and calibers. I haven't updated it in years. Don't even know which computer the spreadsheet is on.

Bren
07-05-2012, 09:00
I've been meaning to do this - Probably just make it a word document with pictures and then convert it to pdf.

racer88
07-05-2012, 12:05
I had been planning to do this for a long time, and this thread inspired me to finally do it... inventorying my ammo! That took some work! And, I've got more ammo than I realized!

MyGunDB has a place to inventory ammo in the program. A cool feature is that you can then display the ammo that corresponds (by caliber) to each firearm in your database. Then you can subtract ammo from the inventory and simultaneously add it to the ammo count for that particular firearm. Very cool!!

I've also just emailed the owner / programmer of MyGunDB with a couple of additional suggestions for the ammo section (to make it easier to add to the inventory as new ammo is purchased).

Cobra64
07-05-2012, 16:58
I just use Excel and build the spreadsheets myself.

It works great.

:agree:

PzGren
07-05-2012, 22:07
I just use Excel and build the spreadsheets myself.

It works great.

Great minds think alike:cool:.

efman
07-05-2012, 22:13
tag for the good info

The_Gun_Guru
07-05-2012, 22:34
I put all my receipts in envlopes and keep them in the safe.

Do you know how long it would take me to put them into Excel?

I don't have that kind of time!


TGG

M2 Carbine
07-06-2012, 07:18
inventorying my ammo!
I can't imagine what a chore it would be to inventory my ammo.
Then trying to keep up with what I shoot and buy/reload would be a royal PITA.

SigFTW
07-06-2012, 07:30
A little Google time and study recommends this one pretty highly:

http://www.nmcollector.net/nmguncollector/downloads/Free/index.htm

Looks like pics are easily included.

This is what I use. :thumbsup:

racer88
07-06-2012, 07:59
I can't imagine what a chore it would be to inventory my ammo.
Then trying to keep up with what I shoot and buy/reload would be a royal PITA.

Now that I've done the initial data entry, it should be quite easy. When I buy some, I'll add it to the DB. When I shoot it, I'll subtract it and simultaneously add it to the round count. Easy-peasy. I've got all my ammo in ammo cans in my closet, so I can't do a quick look-see to determine what I've got and what I'm running low on.

I don't reload, though.

But, I do understand some folks just don't care about these things. :yawn:

Toyman
07-06-2012, 08:08
Using a spreadsheet for a gun inventory is like using a 300 win mag for squirrel hunting, it will get the job done, but not in the best fashion and that's not what they're meant for.

PzGren
07-06-2012, 21:28
Using a spreadsheet for a gun inventory is like using a 300 win mag for squirrel hunting, it will get the job done, but not in the best fashion and that's not what they're meant for.

Wouldn't that also depend on the inventory; the number of guns and changes to it? A spread sheet is a tool that was made to fill data in and updating it for an overview.

I also use spreadsheets to follow prices on collectible guns, like Lugers or WWII P38s.

M2 Carbine
07-06-2012, 21:49
Now that I've done the initial data entry, it should be quite easy. When I buy some, I'll add it to the DB. When I shoot it, I'll subtract it and simultaneously add it to the round count. Easy-peasy. I've got all my ammo in ammo cans in my closet, so I can't do a quick look-see to determine what I've got and what I'm running low on.
This hardly even scratches the surface.
http://i1183.photobucket.com/albums/x464/Bell-helicopter-407/hotweatherreloads.jpg

http://i1183.photobucket.com/albums/x464/Bell-helicopter-407/9mmWWB.jpg

http://i1183.photobucket.com/albums/x464/Bell-helicopter-407/Ammoin50calcans.jpg

http://i1183.photobucket.com/albums/x464/Bell-helicopter-407/45incans.jpg

http://i1183.photobucket.com/albums/x464/Bell-helicopter-407/45and38reloads.jpg

http://i1183.photobucket.com/albums/x464/Bell-helicopter-407/bulletcabinet.jpg

No, keeping up with my ammo on hand and what's used/replaced would be a chore. Way too much like work and I don't like having to constantly keep records up to date.
Heck, I don't even know how many guns I have (although I could look at the Excel spread sheet if I needed to know.


I once counted all the primers and powder on hand but lost interest in keeping up with it within a month.
I just figure I'm getting very low when I'm under 5,000 of each type primer.




.

racer88
07-06-2012, 22:00
This hardly even scratches the surface.

No, keeping up with my ammo on hand and what's used/replaced would be a chore. Way too much like work.
.

That's what I call a "good problem to have!" :faint:

M2 Carbine
07-06-2012, 22:39
That's what I call a "good problem to have!"
Yes it is.:)

It's not a bad idea knowing what you have on hand and I would be interested in knowing, but in my case it would just be too time consuming.

This week for example. I recently came by a Glock 33 .357 SIG. I bought the dies, brass, etc. and have been reloading for it at the same time I have been shooting some of the reloads, most every day.
The G33 is just one gun I shot in the last ten days or so. The others being a M1 Garand, Ruger SR22, Ruger 9mm Police Service Six, Beretta Mod 96D 40 S&W, 17 HMR, Ruger break down 10/22, Ruger Charger, two Ruger SR9C, and several others.
So keeping up with what ammo was shot when is too much work.
Maybe I need to hire an attractive secretary. She would have to like guns though.:supergrin:

HKLovingIT
07-07-2012, 06:18
This hardly even scratches the surface.
http://i1183.photobucket.com/albums/x464/Bell-helicopter-407/hotweatherreloads.jpg

http://i1183.photobucket.com/albums/x464/Bell-helicopter-407/9mmWWB.jpg

http://i1183.photobucket.com/albums/x464/Bell-helicopter-407/Ammoin50calcans.jpg

http://i1183.photobucket.com/albums/x464/Bell-helicopter-407/45incans.jpg

http://i1183.photobucket.com/albums/x464/Bell-helicopter-407/45and38reloads.jpg

http://i1183.photobucket.com/albums/x464/Bell-helicopter-407/bulletcabinet.jpg

No, keeping up with my ammo on hand and what's used/replaced would be a chore. Way too much like work and I don't like having to constantly keep records up to date.
Heck, I don't even know how many guns I have (although I could look at the Excel spread sheet if I needed to know.


I once counted all the primers and powder on hand but lost interest in keeping up with it within a month.
I just figure I'm getting very low when I'm under 5,000 of each type primer.




.


Still waiting for you to mail in those adoption papers. Daddy, when I can move in?

Lowjiber
07-07-2012, 06:26
Using a spreadsheet for a gun inventory is like using a 300 win mag for squirrel hunting, it will get the job done, but not in the best fashion and that's not what they're meant for.
I'm considered an Excel master by many. I totally agree with Toyman.

Perhaps, my opinion is tainted by the fact that I only own fifteen handguns, two shotguns, and one rifle. My ammunition is simply stacked by caliber in its own safe and I rotate on a FIFO concept.

I hardly need to build the simple spreadsheet that would "keep track" of my meager arsenal. Besides, who would have the time to update it every time you fired a weapon or bought another two hundred rounds at Wally World?

Just my $0.02 worth...

M2 Carbine
07-07-2012, 07:13
Still waiting for you to mail in those adoption papers. Daddy, when I can move in?
Sorry, but I can't afford a dependent. All my spare money is tied up un guns and ammo.:supergrin:


I hardly need to build the simple spreadsheet that would "keep track" of my meager arsenal
You have to have the gun info somewhere.
I find a simple Excel spread sheet works fine. It contains all the info about the gun, including where I got it, cost, etc.
And several copies of the file can be put on other computers, flash drives, etc, for safe keeping.

For someone like me, that's lazy keeping records, the simple spread sheet works fine. One gun, one line.
Then copy the updated file to 4-5 different locations for safekeeping.

racer88
07-07-2012, 07:14
I'm considered an Excel master by many. I totally agree with Toyman.

Perhaps, my opinion is tainted by the fact that I only own fifteen handguns, two shotguns, and one rifle. My ammunition is simply stacked by caliber in its own safe and I rotate on a FIFO concept.

I hardly need to build the simple spreadsheet that would "keep track" of my meager arsenal. Besides, who would have the time to update it every time you fired a weapon or bought another two hundred rounds at Wally World?

Just my $0.02 worth...

Understandable. But, some of us have an OCD streak in us! :D

I'm on my computer constantly. It will take me less time to update my inventory than it takes to pay for my ammo at Wallyworld. Literally seconds. This is especially true with MyGunDB. It took me longer to write this post.

racer88
07-07-2012, 07:15
Maybe I need to hire an attractive secretary. She would have to like guns though.:supergrin:

Now that could be a GOOD problem... or a BAD problem... depending on your current marital status! ;)

pesticidal
07-07-2012, 07:22
Using a spreadsheet for a gun inventory is like using a 300 win mag for squirrel hunting, it will get the job done, but not in the best fashion and that's not what they're meant for.

I'm considered an Excel master by many. I totally agree with Toyman.

Perhaps, my opinion is tainted by the fact that I only own fifteen handguns, two shotguns, and one rifle. My ammunition is simply stacked by caliber in its own safe and I rotate on a FIFO concept.

I hardly need to build the simple spreadsheet that would "keep track" of my meager arsenal. Besides, who would have the time to update it every time you fired a weapon or bought another two hundred rounds at Wally World?

Just my $0.02 worth...

The problem with being a "master" at Excel is that you tend to overdo things with it. Excel can also be used to do a simple thing like a firearms log. Just because it's a powerful program doesn't mean you have to use all the bells and whistles.

And it's not like using a .300 Win Mag for a small varmint. Excel, as a firearm, would be multi-caliber.

Hines57
07-07-2012, 12:54
Maybe the excel masters can help me out.
Can you imbed thumbnails in Excel?
Is there a way to make a cover sheet, like a table of contents that would link to each guns page? Or can I put photos in rows and then collapse the rows?

Z71bill
07-07-2012, 13:24
My Excel spread sheet had a separate tab for

Guns - including all the stuff like dates purchased - purchase price - current value -

ammo - by caliber & also indicates where it is stored -

Spare parts inventory for each gun

Magazines by gun & capacity

Cleaning tab shows - date last field stripped - when last detail cleaning.

I also have a tab for AK compliance & a detail sheet for my C&R guns with all the AFT requirements.

I was keeping a tab on number of rounds fired per gun - but after a while that seemed like overkill. :whistling: So i stopped doing it.

Z71bill
07-07-2012, 13:29
Maybe the excel masters can help me out.
Can you imbed thumbnails in Excel?
Is there a way to make a cover sheet, like a table of contents that would link to each guns page? Or can I put photos in rows and then collapse the rows?

I think you want to use a data base program like Microsoft Access -

Paul53
07-07-2012, 13:43
For home use, if you don't want to pay Microsofts ransom, Open Office is a full featured office suite quite similar to Microsofts product, except it's free. It has a spreadsheet program that I've used to make my own form to keep track of my guns, etc. It also has a database program.

The Excel master is correct in that we're using a spreadsheet program as a database program tracking our toys, but I don't see the harm.

I've used Open Office (www.openoffice.org (http://www.openoffice.org)) for a number of years, put it on computers I build, and recomend it to my friends who are happy with it. No, I'm not affiliated with nor paid by the open source people who offer it.

ca survivor
07-07-2012, 14:24
I just use Excel and build the spreadsheets myself.

It works great.
didn't know Excel had that much memory/capacity :rofl:

PzGren
07-07-2012, 23:03
didn't know Excel had that much memory/capacity :rofl:

Everytime BAC is printing a copy of his gun inventory, he has to change the toner cartridge:rofl:.

M2 Carbine
07-08-2012, 07:46
My Excel spread sheet had a separate tab for

Guns - including all the stuff like dates purchased - purchase price - current value -

ammo - by caliber & also indicates where it is stored -

Spare parts inventory for each gun

Magazines by gun & capacity

Cleaning tab shows - date last field stripped - when last detail cleaning.

I also have a tab for AK compliance & a detail sheet for my C&R guns with all the AFT requirements.

I was keeping a tab on number of rounds fired per gun - but after a while that seemed like overkill. :whistling: So i stopped doing it.
That's cool.:)
I wish I wasn't too lazy to do that.
I haven't got a clue how many magazines I have or how much ammo.

pesticidal
07-08-2012, 17:12
Maybe the excel masters can help me out.
Can you imbed thumbnails in Excel?
Is there a way to make a cover sheet, like a table of contents that would link to each guns page? Or can I put photos in rows and then collapse the rows?

I'm no master, for sure, but maybe I can help. If you re-name the tabs, you then can start on tab 1, say TOC for Table of Contents, Tab 2 for pistols, Tab 3 for rifles, etc. For each cell, you can right click and hyperlink to the tab of your choice.

You can also insert a picture and hyperlink it.

FireForged
07-08-2012, 20:51
Spiral notebook but then again... I am an old dude.

Hines57
07-08-2012, 21:34
I'm no master, for sure, but maybe I can help. If you re-name the tabs, you then can start on tab 1, say TOC for Table of Contents, Tab 2 for pistols, Tab 3 for rifles, etc. For each cell, you can right click and hyperlink to the tab of your choice.

You can also insert a picture and hyperlink it.

Very cool, looks like that will work. May take some fine tuning.

:bowdown: :drink:

Glockworks
07-09-2012, 04:20
I just use Excel and build the spreadsheets myself.

It works great.
Ditto. The $39.95 spreadsheet looks cool, but my selfmade excel spreadsheet does what I need it and I can modify it at will in any way I want to.

racer88
07-09-2012, 05:35
Ditto. The $39.95 spreadsheet looks cool, but my selfmade excel spreadsheet does what I need it and I can modify it at will in any way I want to.

Technically speaking, MyGunDB isn't a spreadsheet. It's a database. There is a difference.