Parker Gun Collectors Association Forums  

Go Back   Parker Gun Collectors Association Forums Parker Forums General Parker Discussions

Notices

Reply
Thread Tools Display Modes
Gun Inventory
Unread 01-17-2012, 02:23 PM   #1
Member
David Weber
PGCA Lifetime
Member

Member Info
 
Join Date: Nov 2010
Posts: 98
Thanks: 578
Thanked 181 Times in 38 Posts

Default Gun Inventory

I'm looking for software or an excel spreadsheet to inventory my guns. Anybody?
David Weber is offline   Reply With Quote
Unread 01-17-2012, 02:41 PM   #2
Member
Big D
PGCA Member
 
John Dallas's Avatar

Member Info
 
Join Date: Nov 2008
Posts: 4,470
Thanks: 502
Thanked 3,918 Times in 1,667 Posts

Default

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.
John Dallas is offline   Reply With Quote
Unread 01-17-2012, 02:51 PM   #3
Member
J.B. Books
PGCA Member
 
Pete Lester's Avatar

Member Info
 
Join Date: Jun 2009
Posts: 3,043
Thanks: 1,837
Thanked 5,404 Times in 1,504 Posts

Default

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
Pete Lester is offline   Reply With Quote
Unread 01-17-2012, 03:02 PM   #4
Member
OH Osthaus
PGCA Lifetime
Member
 
Rick Losey's Avatar

Member Info
 
Join Date: Jul 2010
Posts: 7,931
Thanks: 1,769
Thanked 8,544 Times in 3,345 Posts

Default

Don't forget to photograph them. Even if it does't fit the spreadsheet format.
__________________
"If there is a heaven it must have thinning aspen gold, and flighting woodcock, and a bird dog" GBE
Rick Losey is offline   Reply With Quote
Unread 01-17-2012, 05:44 PM   #5
Member
Captain Bob
Moderator
 
Bob Roberts's Avatar

Member Info
 
Join Date: Nov 2008
Posts: 105
Thanks: 962
Thanked 174 Times in 51 Posts

Default

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.
__________________
Bob Roberts
Bob Roberts is offline   Reply With Quote
The Following 3 Users Say Thank You to Bob Roberts For Your Post:
Visit Bob Roberts's homepage!
Unread 01-17-2012, 06:21 PM   #6
Member
J.B. Books
PGCA Member
 
Pete Lester's Avatar

Member Info
 
Join Date: Jun 2009
Posts: 3,043
Thanks: 1,837
Thanked 5,404 Times in 1,504 Posts

Default

Quote:
Originally Posted by Bob Roberts View Post
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.
Pete Lester is offline   Reply With Quote
Unread 01-17-2012, 06:56 PM   #7
Member
Hammer Gun
PGCA Lifetime
Member
 
Gary Carmichael Sr's Avatar

Member Info
 
Join Date: Nov 2008
Posts: 3,694
Thanks: 2,846
Thanked 8,004 Times in 1,703 Posts

Default

Captain Bob, Ilike your ser # Invincible 200000
Gary Carmichael Sr is offline   Reply With Quote
Unread 01-17-2012, 07:37 PM   #8
Member
Mike Phelps
Forum Associate

Member Info
 
Join Date: Nov 2011
Posts: 37
Thanks: 3
Thanked 17 Times in 6 Posts

Default

I use a spreadsheet, but this software has gotten some good reviews
http://myifsgundb.com/
Mike Phelps is offline   Reply With Quote
The Following User Says Thank You to Mike Phelps For Your Post:
Unread 01-17-2012, 09:27 PM   #9
Member
Larry the Gun Guy
PGCA Member
 
Larry Stauch's Avatar

Member Info
 
Join Date: Feb 2011
Posts: 1,003
Thanks: 3,394
Thanked 1,976 Times in 472 Posts

Default

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.
Larry Stauch is offline   Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 09:59 PM.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright © 1998 - 2025, Parkerguns.org
Copyright © 2004 Design par Megatekno
- 2008 style update 3.7 avec l'autorisation de son auteur par Stradfred.