Need a spreadsheet/Record for guns

Need a spreadsheet/Record for guns

This is a discussion on Need a spreadsheet/Record for guns within the General Firearm Discussion forums, part of the Related Topics category; 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 ...

Page 1 of 2 12 LastLast
Results 1 to 15 of 22

Thread: Need a spreadsheet/Record for guns

  1. #1
    VIP Member Array dukalmighty's Avatar
    Join Date
    Feb 2008
    Location
    texas
    Posts
    15,179

    Need a spreadsheet/Record for guns

    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.
    "Outside of the killings, Washington has one of the lowest crime rates in the country,"
    --Mayor Marion Barry, Washington , DC .


  2. #2
    VIP Member Array wmhawth's Avatar
    Join Date
    Apr 2007
    Location
    Western Colorado
    Posts
    4,487
    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.

  3. #3
    VIP Member
    Array ppkheat's Avatar
    Join Date
    May 2007
    Location
    Louisiana
    Posts
    4,159
    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.

    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.
    Turn the election's in 2014 to a "2A Revolution". It will serve as a 1994 refresher not to "infringe" on our Second Amendment. We know who they are now.........SEND 'EM HOME. Our success in this will be proportional to how hard we work to make it happen.

  4. #4
    VIP Member Array dukalmighty's Avatar
    Join Date
    Feb 2008
    Location
    texas
    Posts
    15,179
    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
    "Outside of the killings, Washington has one of the lowest crime rates in the country,"
    --Mayor Marion Barry, Washington , DC .

  5. #5
    Member Array ispcapt's Avatar
    Join Date
    Nov 2005
    Location
    IL
    Posts
    319
    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.
    183 FBINA

  6. #6
    VIP Member Array varob's Avatar
    Join Date
    Jun 2009
    Location
    Virginia
    Posts
    4,456
    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.
    Don't believe what you hear and only half of what you see!
    -Tony Soprano

  7. #7
    Senior Member Array mr surveyor's Avatar
    Join Date
    Jul 2006
    Location
    Texas, South of the Sabine
    Posts
    1,149
    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

    surv

  8. #8
    Distinguished Member Array Chooie's Avatar
    Join Date
    Oct 2006
    Location
    Virginia
    Posts
    1,870
    Quote Originally Posted by varob View Post
    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.

  9. #9
    VIP Member Array dukalmighty's Avatar
    Join Date
    Feb 2008
    Location
    texas
    Posts
    15,179
    Thanks guys,I like the idea of cards with info and pics,with price
    "Outside of the killings, Washington has one of the lowest crime rates in the country,"
    --Mayor Marion Barry, Washington , DC .

  10. #10
    VIP Member
    Array dr_cmg's Avatar
    Join Date
    Feb 2006
    Location
    Alabama
    Posts
    10,808
    You might want to try GunSafe software. It is free and has space for all the details and then some including photos.

    GunSafe - Firearms Collection Software
    George

    Two things are infinite: the universe and human stupidity; and I'm not sure about the universe. Albert Einstein

  11. #11
    Member Array Freakdaddy's Avatar
    Join Date
    Oct 2006
    Location
    Missouri
    Posts
    245
    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.

  12. #12
    VIP Member Array dukalmighty's Avatar
    Join Date
    Feb 2008
    Location
    texas
    Posts
    15,179
    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.
    "Outside of the killings, Washington has one of the lowest crime rates in the country,"
    --Mayor Marion Barry, Washington , DC .

  13. #13
    Member Array llongshot's Avatar
    Join Date
    Jan 2009
    Location
    Deep Southern Illinois
    Posts
    276
    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.

  14. #14
    Member Array inspyrd's Avatar
    Join Date
    Nov 2008
    Location
    Minnesota
    Posts
    37
    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.

  15. #15
    Member Array stolivar's Avatar
    Join Date
    Dec 2004
    Posts
    211

    Cool program

    Better than my software I paid for.


    steve

Page 1 of 2 12 LastLast

Links

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Similar Threads

  1. Spreadsheet of OC/CC for States I Visit
    By tkruf in forum Concealed Carry Issues & Discussions
    Replies: 29
    Last Post: April 27th, 2010, 09:11 AM
  2. 50 State Spreadsheet
    By tkruf in forum Concealed Carry Issues & Discussions
    Replies: 6
    Last Post: April 26th, 2010, 03:11 PM
  3. For the record, I have sold ALL of my guns!!!!
    By Free American in forum Off Topic & Humor Discussion
    Replies: 13
    Last Post: January 30th, 2009, 05:34 PM
  4. 'Gifts for Guns' Gets Record Haul
    By j21blackjack in forum In the News: The Good, the Bad and the Ugly
    Replies: 28
    Last Post: December 10th, 2008, 12:37 PM
  5. hypothetical question regarding guns and criminal record
    By the-fly in forum General Firearm Discussion
    Replies: 8
    Last Post: May 10th, 2005, 11:26 PM

Search tags for this page

firearm inventory spreadsheet

,
firearm record sheet
,
firearm record sheet download
,

firearms inventory spreadsheet

,
firearms record sheet
,
firearms spreadsheet
,

gun inventory sheet

,

gun inventory spreadsheet

,
gun inventory spreadsheet free
,
personal firearms inventory sheet
,
personal firearms record excel
,
personal firearms record sheet
Click on a term to search for related topics.