Taking inventory...

Gun related chat that doesn't fit in another forum

Taking inventory...

Postby Rodentman on Sat Dec 23, 2017 10:53 am

With time on my hands, and cold weather coming, I have decided to take inventory of my guns. I have started a spreadsheet with columns for mfr, caliber, SN, etc. I don't know when I'll be done since I'm doing it a bit at a time. It's fun to go thru everything and keep better track of it.
User avatar
Rodentman
 
Posts: 2740 [View]
Joined: Sat Feb 07, 2009 9:22 am

Taking inventory...

Postby gun_fan111v2 on Sat Dec 23, 2017 11:05 am

I think Bud's has their GunDB for phones now and it might be free. Has some nice features if you are willing to do constant data entry :)

I too use excel though to keep it simple. I record the date purchased and it is interesting to look back and see the different trends.
User avatar
gun_fan111v2
 
Posts: 1110 [View]
Joined: Thu Feb 19, 2015 9:31 pm

Re: Taking inventory...

Postby rtk on Sat Dec 23, 2017 11:05 am

Is this what I can look forward to when I retire?
The sky is falling, the sky is falling....(Chicken Little)
User avatar
rtk
 
Posts: 3097 [View]
Joined: Thu Jul 26, 2007 3:34 pm

Re: Taking inventory...

Postby Rodentman on Sat Dec 23, 2017 11:10 am

I don't think I could use my phone for this since it is hanging on the wall in my kitchen where the good Lord intended it to be.

It's a good retirement activity since it doesn't cost anything and passes the time. I spent all my $ on firearms and reloading stuff.
User avatar
Rodentman
 
Posts: 2740 [View]
Joined: Sat Feb 07, 2009 9:22 am

Taking inventory...

Postby gun_fan111v2 on Sat Dec 23, 2017 11:24 am

rtk wrote:Is this what I can look forward to when I retire?


This and renting tables at gun shows to showcase the collection. Seems like there is always somebody there with sky high prices because they came to mingle and not to deal. Good times!
User avatar
gun_fan111v2
 
Posts: 1110 [View]
Joined: Thu Feb 19, 2015 9:31 pm

Re: Taking inventory...

Postby westhope on Sat Dec 23, 2017 12:30 pm

Add a column for a link to photos of the gun.

Make a copy of the spreadsheet and photos. Store off site for insurance purposes.

(Encrypt the file so your wife can't see it!)

I'm also retired.
Because I care, I carry.
User avatar
westhope
 
Posts: 1699 [View]
Joined: Sat Jul 28, 2007 8:55 am
Location: West of Hope, MN. (South Central MN)

Re: Taking inventory...

Postby Randygmn on Sat Dec 23, 2017 1:03 pm

westhope wrote:Add a column for a link to photos of the gun.

Make a copy of the spreadsheet and photos. Store off site for insurance purposes.

(Encrypt the file so your wife can't see it!)

I'm also retired.


Exactly. I created a folder in my iPhone photos where I have pictures of all my firearms and serial numbers with any associated paperwork in case there’s ever a question in case they are stolen. Fwiw.
Randygmn
 
Posts: 901 [View]
Joined: Sun Dec 15, 2013 3:52 pm

Re: Taking inventory...

Postby yukonjasper on Sat Dec 23, 2017 1:47 pm

Excellent idea.
Deo Adjuvante Non Timendum - (with the help of God there is nothing to be afraid of)
Spectamur Agendo - (We are proven by our actions)
Non Ducor, Duco - (I am not led, I lead)
NRA Life Member
User avatar
yukonjasper
 
Posts: 5823 [View]
Joined: Wed Feb 06, 2008 3:31 pm
Location: eagan

Re: Taking inventory...

Postby mmcnx2 on Sat Dec 23, 2017 3:58 pm

I use excel and provide an updated list to my insurance carrier annually. I also store it on a cloud drive so I can see it anywhere. I include, brand, model, caliber, accessories, customization, place of purchase, pricing paid and of course serial number. I also have a picture of each, which i update annually. The other thing I do is put a reminder in my calendar for each to remind me to clean them all twice a year.
User avatar
mmcnx2
 
Posts: 2208 [View]
Joined: Sun Dec 16, 2007 2:59 pm
Location: Hanover, MN

Re: Taking inventory...

Postby Rodentman on Sat Dec 23, 2017 4:49 pm

I don't know if I'll live long enough to get all that info into a spreadsheet. The photos and customization lists would be really time consuming. I DO have hard copies of all pertinent data in my file cabinet. Expanding the data recorded is a good idea. Maybe I'll work on that once I get the initial listing done.
User avatar
Rodentman
 
Posts: 2740 [View]
Joined: Sat Feb 07, 2009 9:22 am

Re: Taking inventory...

Postby Ghost on Sat Dec 23, 2017 5:06 pm

I’m scared to know how many I have.
User avatar
Ghost
 
Posts: 8246 [View]
Joined: Wed Feb 05, 2014 8:49 pm

Re: Taking inventory...

Postby yukonjasper on Sat Dec 23, 2017 5:28 pm

It certainly challenges you to confront the "problem". :lol:
Deo Adjuvante Non Timendum - (with the help of God there is nothing to be afraid of)
Spectamur Agendo - (We are proven by our actions)
Non Ducor, Duco - (I am not led, I lead)
NRA Life Member
User avatar
yukonjasper
 
Posts: 5823 [View]
Joined: Wed Feb 06, 2008 3:31 pm
Location: eagan

Re: Taking inventory...

Postby Ironbear on Sat Dec 23, 2017 5:31 pm

yukonjasper wrote:It certainly challenges you to confront the "problem". :lol:

The first step is getting past "denial"! :;-)

Sent from my Nexus 7 using Tapatalk
"Justice and power must be brought together, so that whatever is just may be powerful, and whatever is powerful may be just.” ~Blaise Pascal~
User avatar
Ironbear
 
Posts: 2178 [View]
Joined: Sat Jul 28, 2007 4:38 pm
Location: A nondescript planet in the Milky Way galaxy

Re: Taking inventory...

Postby hard h2o on Sun Dec 24, 2017 12:40 am

On my spreadsheet I have make, model, chambering, serial number, when purchased, MSRP at that time, optics, and any special features like type of stock...

My insurance agent was very happy. Helped with the rider on the homeowners.

Agent has a copy, copy on the computer, copy on memory stick stored off site.

Sadly, my stable is not as vast as many of yours so it did not take me long to complete.

Easier to update when needed than it is to try to recreate after a catastrophic event.
hard h2o
 
Posts: 734 [View]
Joined: Mon Oct 17, 2011 1:08 pm
Location: Oakdale, MN

Re: Taking inventory...

Postby hard h2o on Sun Dec 24, 2017 12:41 am

yukonjasper wrote:It certainly challenges you to confront the "problem". :lol:


What problem? Each one was an opportunity not a problem.
hard h2o
 
Posts: 734 [View]
Joined: Mon Oct 17, 2011 1:08 pm
Location: Oakdale, MN

Next

Return to General Gun Chat

Who is online

Users browsing this forum: No registered users and 15 guests

cron