Personal gun database file BIG HELP (check mine out)

[sturmruger]

When I first started perusing all of the gun discussion sites I started noticing that many people kept track of exactly how many rounds they have fired out of a particular gun. I have been trying to come up with a good way to keep track of how many rounds I have fired through my guns. I also decided that I needed a way to keep track of exactly which guns I would like to own in the future. I am tired of buying whatever gun happens to strike my fancy. I needed to have some sort of purpose to what I am purchasing. I decided that I could compile this all into one excel file and keep track of allot of information in one source. After compiling all of the guns I want with the guns I have, I found out a few interesting things. I have spent around $3200 so far on the guns that I own, not bad for someone who is only 26. To get all of the guns on my list I will need to spend another $12K!!! Ouch I think I better keep this list away from my wife.



I am including an old copy of my personal list all filled in, and a link to the excel file incase anyone wants to use the same file for their own use. This list does reflect my own personal taste if you don't agree with something I am hoping to purchase someday please keep it to yourself. This thread isn't to discuss what guns I plan to purchase, it is to help people keep track of their gun collection. I look forward to peoples on topic comments.


HTML File of my Gun List


Template file (to save right click choose "save target as")




I am not an excel whiz so if anyone can improve on this file please email me a copy I would love to have it. I thought about trying to include a total cost for rounds fired for each gun.

 

[QuarterBoreGunner]

Pretty cool stuff.

I asked about firearm collection software
here and found that most people seem to use Excel also.

I've been using GunTracker and it works just fine for me; as a plus I like having a digital copy of the Blue Book integrated with it. The picture/graphics portion of the software needs work though.

 

[ajacobs]

linky no worky

opps now it appears to work

 

[sturmruger]

I just tried it and from two computers and two differant browsers. It should be working just fine. Although my host did go down for a day last week, but that was the first time in a couple of years.

 

[grnzbra]

:banghead: Aargh!:banghead:
Using a spreadsheet as a database!

 

[sturmruger]

Grnzbra I guess you are right "Database" is probably the wrong word to use. It is after all only a spreadsheet, but for those of us that are not gifted in how to use Access or other database software the spreadshet get us by just fine.

 

[grnzbra]

sturmruger,

please don't mind me; I'm an Access programmer who, for the last 5 years has been forced to create reports in Access that really belong in Excel and, just for the joy of programming, tends to guild the lilly whenever the opportunity arises. It's a perfectly fine database. As long as things don't get too complex, either one can be used.

 

[DragonRider]

This is off of a guy at Glocktalk and has worked very well for me

http://glocktalk.com/showthread.php?threadid=80324&goto=newpost

It calculates reloading cost, round count through each firearm, and is very well done.

John