Defensive Carry banner

1 - 20 of 22 Posts

·
Registered
Joined
·
15,177 Posts
Discussion Starter #1
Does anybody have a spreadsheet type file for recording guns,I have acquired way too many and I need to go thru and record every gun and serial number with descriptions/scope accessories etc. for theft/insurance purposes.I have at least 40 firearms to record.
 

·
Registered
Joined
·
6,966 Posts
If you have a Quicken program the Quicken Home Inventory works pretty well for your gun inventory or if you have excel it would be easy enough to taylor a spreadsheet to your own needs. I personally keep mine in the Quicken Home Inventory.
 

·
Premium Member
Joined
·
4,456 Posts
I just finished putting my guns on a simple Excel spread sheet. I noticed my wife was mighty interested to know exactly how many guns I had. Probably a waste of my time to go to that much trouble for three guns though. :image035:

Here are my categories, of course your criteria may differ.

Type- rifle, handgun, shotgun, other
Manufacturer- Remington, Browning, etc
Country- where manufactured
C&R- is it a C&R gun
Action- bolt, semi-auto, dbl bbl, revolver, etc
Model-self explanatory
Serial number - self explanatory
Caliber/gauge- self explanatory
Location- where the gun is normally stored
New/used- did I acquire it new or used
Notes- refers to another sheet where I might elaborate further, that it was my grandfathers gun or whatever, and any unique or historical about it, nuances or whatever.

I think it goes without saying you'd want to keep a spread sheet like this in a secure place. Available for insurance reasons, yet secure enough to maintain privacy.
 

·
Registered
Joined
·
15,177 Posts
Discussion Starter #4
I have a partial list written down and saved,but over the last few months I've acquired a bunch and been too lazy to add them,not to mention the list needs to be better organised,for Insurance and In case I pass my daughter will receive a large cache of guns and needs to know approximate resell value
 

·
Registered
Joined
·
319 Posts
Here's a flat file where you can do what you're asking and also has a lot more features. Can't beat the price - free.
HuntingNut News Official PointBlank downloads Page

You can also keep track of load information if you reload. Also has a ballistic calculator, calculator ballistic coefficient, sectional density, recoil calculator, muzzle energy, Taylor knockout formula, and English/Metric converter.
 

·
Registered
Joined
·
4,469 Posts
We do something a little diferent. We take photos of each weapon, tape it to print out of all the info about it. Keep it in safe deposit box at bank.
 

·
Registered
Joined
·
1,149 Posts
I hand write notes with a sharpie on plain white paper with the model, make, sn or other info. Then lay the gun down beside it, and snap pics. Then pics are made of the sales slip, warranty card, manual, and any other printed data. The case (if included) and all other accessories get photo'd. Multiple pics of the gun from all angles, including all stamping or other marks. Then all the photo's for that particular gun are downloaded into a folder specific for that gun and stored on cd's. When one leaves my collection, a note describing the transaction gets a pic, added to the folder, and the folder gets moved to a "guns no longer owner" category. Guns I picked up or sold in FtoF deals have a handwritten description of the transaction photo'd and included in the appropriate folder. I still keep all the paper, but the digital pics of the paper ARE my inventory control:smile:

surv
 

·
Registered
Joined
·
1,870 Posts
We do something a little diferent. We take photos of each weapon, tape it to print out of all the info about it. Keep it in safe deposit box at bank.
I do something similar - digital photos embedded in an Access database, stored on CD-R and flash drive in the safe, as well as another CD-R in the other firebox.
 

·
Registered
Joined
·
15,177 Posts
Discussion Starter #9
Thanks guys,I like the idea of cards with info and pics,with price
 

·
Registered
Joined
·
245 Posts
I also use the Excel spreadsheet and it works great. I include in mine the date acquired, price paid and date of manufacture. I also have a column for "Current Value" which helps give value to my older guns I've inherited that I keep updated every couple of years. This way is something was to happen to me, my family would have a good idea of what the value is of that particular gun. My other categories are very similar to ppkheat's listed ones. The nice thing about Excel is you can set it up any way you want to and it's fairly user friendly.
 

·
Registered
Joined
·
15,177 Posts
Discussion Starter #12
The Gunsafe site DR CMG provided is great ,once I figured out how to download and open and find it and started playing with it,you can add as many pics of each gun as you want along with info on if you ever sell it,then you can also put the info on a CD that you can store in your safe etc.
 

·
Registered
Joined
·
276 Posts
You already have a custom program. All you need is a "pivot table" to allow you to access the guns you want to see. Make sure your headings are bold or a larger font or both so the program can differentiate between data and headings. Highlight your headings. Go to the data tab. Click the Pivot table and pivot chart report. Click next. Your headings should be highlighted. Click finish. You should have a little down arrow next to each heading that, when selected, will allow you to pull up all the guns you have within the criteria in that heading. If you have manufacturer as a heading you can select "Winchester" and see all your Winchesters. If "type" is another heading you can then select "handgun" and see all your Winchester handguns. Don't forget to return the little arrows back to "all" before you close the file.
 

·
Registered
Joined
·
37 Posts
I also use an excel spread sheet. I include all of the following information and photos.

Manufacturer, Model, Caliber, Serial Number, Location purchased, Date Purchased, Purchase Price, Location Sold, Date Sold, Selling Price and a section for notes.

Photos - 4 total

Full Left Side Profile, Full Right Side Profile, Close up of Left side serial numbers and misc stamping, Close up of Right side serial numbers and misc stamping.
 

·
Registered
Joined
·
10,807 Posts
The Gunsafe site DR CMG provided is great ,once I figured out how to download and open and find it and started playing with it,you can add as many pics of each gun as you want along with info on if you ever sell it,then you can also put the info on a CD that you can store in your safe etc.
Wish I could take credit for finding it, but I read about it here several years ago and have been using it since.

I like the fact that even if you get rid of a firearm the data is available. I usually use the Current Collection view, but occasionally I want to know something about a gun I no longer have and the View All makes that easy.
 

·
Registered
Joined
·
74 Posts
If you have a Quicken program the Quicken Home Inventory works pretty well for your gun inventory or if you have excel it would be easy enough to taylor a spreadsheet to your own needs. I personally keep mine in the Quicken Home Inventory.
FYI, The Quicken Home Inventory program will not work with the 64 bit Windows Vista system yet. Tried downloading it last weekend and had to get a refund from them for it. Great customer service though quick and accurate
 

·
Registered
Joined
·
54 Posts
I use KeePass which is an encrypted database. I use it for all my important data, financial records, passwords etc. It allows me to backup easily with one file and my wife has full access as well.

But I have found it very convenient for all inventory type data as well.

With one password I have access o all my passwords.

Best of all it is free.
 

·
Registered
Joined
·
6,966 Posts
I mentioned in an earlier post here that I have my gun inventory on Excel. Is there a way that I can password protect that "gun inventory folder" to keep others from opening it up?
Yes. When you are in Excel go to the "help" menu and just type in password. You will get instructions on how to password protect your spreadsheet.
 
1 - 20 of 22 Posts
Top