firearm inventory spreadsheet?


PDA






rondog
February 1, 2010, 02:19 PM
Does anybody have a nice "form", "template" or "spreadsheet", or blank document file in either Word or Excel for recording the information about your guns?

I'd like to have an electronic copy of a blank form or template for recording make, model, serial number, description, value, etc., and maybe space for photos too. I have something similar in old printed paper forms, but those are pretty rough. I'd like something I could keep e-copies of, and make printed copies too.

I can use Excel and Word, but I'm no good at creating templates. Anybody have something like this they'd share?

Thanks!

If you enjoyed reading about "firearm inventory spreadsheet?" here in TheHighRoad.org archive, you'll LOVE our community. Come join TheHighRoad.org today for the full version!
Carne Frio
February 1, 2010, 03:14 PM
From a google search:

http://www.thehighroad.org/showthread.php?t=213262

CoRoMo
February 1, 2010, 03:19 PM
I could PM you with my Excel template, but I don't have it on this computer. What I need to do is email it to myself, that way it will be saved in that web email account and I could access it anywhere in the world just by logging into my account. A type of off-site archive.

rondog
February 1, 2010, 04:07 PM
I could PM you with my Excel template, but I don't have it on this computer. What I need to do is email it to myself, that way it will be saved in that web email account and I could access it anywhere in the world just by logging into my account. A type of off-site archive.


That would be great! I'm not looking to buy any software, just an Excel spreadsheet that somebody made is great. Just a fill-in-the-blanks thing.

Oro
February 1, 2010, 05:36 PM
em sent, email me back.

paintballdude902
February 1, 2010, 06:36 PM
i just use the basic spread sheet i put make, model, serial number, caliber

double bogey
February 1, 2010, 06:51 PM
I just started an excel document, no template. Just started with gun #1, model, serial, description, and attached a picture. Then I made a bold border, went onto next gun. Saved it, put copy on a couple of cd's, one in gun safe, one to my brothers for safekeeping. Its eazy to add to or subtract from. Also it can be nearly infinite is size, however not a problem for me. If I get some time, I'll make an empty copy and post it here.

rondog
February 1, 2010, 07:02 PM
My email registered here is my home email, have to get back with ya when I'm home.

Oro
February 1, 2010, 07:33 PM
Send me a pm then with the email you want it sent to just typed in the body of the pm. I'll send it and it will be there when you get home.

leadcounsel
February 1, 2010, 07:40 PM
I looked for a program, and someone here had one called gunlist or something similar. Software that I thought was overly complicated.

I put mine on a simple Excell spreadsheet with make, model, serial, caliber, price paid, date, and other notes (finish, # or mags). When I make an update I email it to myself so that if I'm victim of theft or fire I have a permanent copy on email.

W L Johnson
February 1, 2010, 07:44 PM
Gunsafe maybe?
http://somanyroads.org/gunsafe/
I don't use it myself but read about it in here some time ago.

Labyrinth666
February 1, 2010, 07:45 PM
Why would you want records of every firearm you own? Maybe I'm paranoid, but I wouldn't want anyone to know any of that.

W L Johnson
February 1, 2010, 07:48 PM
Why would you want records of every firearm you own? Maybe I'm paranoid, but I wouldn't want anyone to know any of that.

If they are stolen or lost in anyway it's good to at least have a record of the S/N.

leadcounsel
February 1, 2010, 07:50 PM
Why would you want records of every firearm you own? Maybe I'm paranoid, but I wouldn't want anyone to know any of that.

It only comes into play for insurance purposes or police reports of theft, or to record the disposition. And sometimes I just like to look at my list! :) In my graying years it's a good reference as to where, when and how much my guns were. And emailing it to myself creates a timestamp.

double bogey
February 1, 2010, 08:17 PM
Is there a way to attach an excel sheet?

W L Johnson
February 1, 2010, 08:24 PM
Is there a way to attach an excel sheet?
Attach it to what? If an E-mail there should be an attach button in whatever e-mail program you are using then it's just a matter of selecting the right file.

double bogey
February 1, 2010, 08:37 PM
There is an attach button in the advanced reply section, it will accept word docs but not excel. I wanted to attach the sheet I used.

W L Johnson
February 1, 2010, 08:40 PM
it will accept word docs but not excel.
That's weird, It shouldn't care what type of file you are attaching unless it's trying to insert it into the e-mail instead of attaching it to the e-mail. What E-mail program are you using?

BCCL
February 1, 2010, 08:42 PM
I just keep my list in a free text file encryption program called LockNote.exe.

Milkmaster
February 1, 2010, 08:52 PM
Most email servers like Comcast for instance allows several meg of free storage. You don't have to store it in an email. The email service will have instructions on how to access the files.

I have pictures of each of my firearms along with a word document list with serial numbers etc. Any time the list changes I just overwrite the previous edition with a new one. If they are stolen or a fire burns up my house, the firearms will be replaced.

I also take a video of the contents of my home once per year and store the file there as well. The insurance adjuster tells me that it is the number one problem when folks lose their home. Remembering everything they have to list for insurance purposes.

double bogey
February 2, 2010, 12:20 AM
Not talking about email, talking about replies to a thread in this forum.

obm
February 2, 2010, 12:52 AM
I use the Google Docs spreadsheet:

http://docs.google.com

I have one sheet for firearms inventory, one sheet for a shoot log which acts as an odometer for each firearm.

I also keep track of other stuff like my weekly cycling log to log my miles, average speed, time, etc.

sorry no fancy templates, just basic column headings at top.

-obm

Magic_Man
February 2, 2010, 01:13 AM
I made my own in Excel. I use it to keep track of firearms I currently own, ones I have sold, ammo inventory, accessories & money spent, etc.

double bogey
February 2, 2010, 01:17 AM
Yes, I built one with excel, I was trying to post a sample someone could use easily. Oh well they aren't that hard to make.

hadmanysons
February 2, 2010, 01:41 AM
I use GunSafe. It works great for my purposes, which is record keeping, possible theft and gee wiz purposes

Wildyams
February 2, 2010, 02:07 AM
not sure how the pictures would work, I was thinking maybe upload the pictures online (flickr, photobucket ect.) and put the link to the gun in the document or something?


it seems i can't upload an excel file, but if you want it pm me.

whats on it is-

Manufacturer, Model, Serial Number, Action, Caliber, Date Purchased, Purchased From, Cost, Pictures, Description, Date Sold, Sold To.

Its a lot of information, but I feel most of it is relevant in case something is stolen or used in a crime, you have a record of when you got it for how much and where it went to after you.

huntsman
February 2, 2010, 11:09 AM
Why would you want records of every firearm you own? Maybe I'm paranoid, but I wouldn't want anyone to know any of that.
I keep records of all my gun transactions past and present. Part for insurance and part because as I age my memory starts to fade.:) I've also started to track ammo purchases on a spread sheet.

One word of wisdom: if you're married don't share this info with your wife (I had no choice she set up my sheets) it may cost you big time.;)

wishin
February 2, 2010, 11:25 AM
Yes, I built one with excel, I was trying to post a sample someone could use easily. Oh well they aren't that hard to make.
I've not tried to post an excel spreadsheet here, but try to "Go Advanced" below and click "attachment" icon, then click "browse" and select your file. If that doesn't work it means this bulletin program is not configured for excel documents.

wojownik
February 2, 2010, 11:34 AM
Take a look at this format. http://sportsmansblog.typepad.com/GunListTemplate.xls

While I don't have a C&R license (yet), I've been tracking my firearms invoentory collection in a modified version of the C&R bound book format. Someone helpfully created XLS and PDF versions of the bound book. I like this format, personally, but added some of the purchase price/current value fields as seen in the above template.

http://www.type03.net/BoundBooks/ROsterman-Boundbook.xls

http://www.type03.net/BoundBooks/Bound_Book.pdf

And from another source

http://serellan.3dretreat.com/guns/BOUND_BOOK.xls

Buck Nekkid
February 2, 2010, 11:02 PM
I love GunSafe and have used it for several years. It allows adding actual pics of the firearm, and on and on. The best thing about it...it's free!!

leadcounsel
February 2, 2010, 11:35 PM
http://sportsmansblog.typepad.com/GunListTemplate.xls

Wojownik, that is fantastic. Thanks for sharing. I'm going to change to this spreadsheet system.

leadcounsel
May 25, 2010, 08:15 PM
bump

troymatthew
May 25, 2010, 08:30 PM
I'm the owner of Gunwallet.com If anyone here wants to use the service I'll waive the fee and give you an unlimited membership. It just launched so it'd be good to have some people try it out and give me some feedback. PM me if your interested.

glockman19
May 25, 2010, 08:38 PM
I made an Excel spreadsheet that has Makem Model, serial number, price paid, and a picture. On another Tab I track Maintence by month. On the third tab I track rounds shot by month. a final tab has reloading info.

If you enjoyed reading about "firearm inventory spreadsheet?" here in TheHighRoad.org archive, you'll LOVE our community. Come join TheHighRoad.org today for the full version!