Parker Gun Collectors Association Forums

Parker Gun Collectors Association Forums (https://parkerguns.org/forums/index.php)
-   General Parker Discussions (https://parkerguns.org/forums/forumdisplay.php?f=2)
-   -   Gun Inventory (https://parkerguns.org/forums/showthread.php?t=6166)

David Weber 01-17-2012 02:23 PM

Gun Inventory
 
I'm looking for software or an excel spreadsheet to inventory my guns. Anybody?

John Dallas 01-17-2012 02:41 PM

Why can't you create your own? What features are you looking for that can't be set up on a spreadsheet? I did one what has gun type, manufacturer, model, gauge, caliber, serial number, estimated value, and special notations for unique features, added scopes, etc. PM me with your email, and I'll be happy to send you my format.

Pete Lester 01-17-2012 02:51 PM

I made one for myself years ago, colums are Manufacturer, Grade/Model, gauge.caliber, Serial #, Purchase price, date acquired, bore diameter/chokes, extra equipment, repairs and modifications, notes

Rick Losey 01-17-2012 03:02 PM

Don't forget to photograph them. Even if it does't fit the spreadsheet format.

Bob Roberts 01-17-2012 05:44 PM

My business involves maintaining a very large database of information about the digital photographs which we license for reproduction. Based on 30 years of experience I would offer a particular suggestion if you are intending to keep digital images of the firearms recorded in your spread sheet. The most unique thing about any firearm is its serial number and over time you will experience far less aggravation if you adopt the actual serial number as the primary ID for each firearm record, Then use this convention for naming and storing your images: use the serial number and if you have several shots of the same firearm use the convention of using an underscore and a sequential number after the underscore for each image, e.g. 200000_1.jpg, 200000_2.jpg, 200000_3.jpg It is highly unlikely that you will have more than one firearm with the same serial number.

And remember to always, always BACKUP your spreadsheet to a second drive every time you make a new entry or make a change - an inexpensive flash drive is ideal for this.

Pete Lester 01-17-2012 06:21 PM

Quote:

Originally Posted by Bob Roberts (Post 60272)
And remember to always, always BACKUP your spreadsheet to a second drive every time you make a new entry or make a change - an inexpensive flash drive is ideal for this.

Norton Anti Virus is great for doing this automatically. Simply plug a flash drive into a USB port and then under "Manage Backup Sets" select the E drive as your destination for the backups.

Gary Carmichael Sr 01-17-2012 06:56 PM

Captain Bob, Ilike your ser # Invincible 200000

Mike Phelps 01-17-2012 07:37 PM

I use a spreadsheet, but this software has gotten some good reviews
http://myifsgundb.com/

Larry Stauch 01-17-2012 09:27 PM

I use and like:
The Blue Book of Gun Inventory, https://store.bluebookinc.com/Firearms/ISP.aspx.
You can slide through the listing that are arranged alphabetically and pick your gun out of the Blue Book on line and then click, add it to my inventory. It allows pictures and condition and a lot of useful information.
These are the same people that produce and publish the identification and serialization book that we all refer to so much.


All times are GMT -4. The time now is 11:47 AM.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright © 1998 - 2025, Parkerguns.org