Does anybody have a spreadsheet for keeping up with all their gun info that they would like to share? A friend at work had a few guns stolen and couldn't come up with the serial numbers so I figured I better do something for mine. I know its easy to make one myself but I would like to see how some other people do theirs. Thanks in advance.
Spreadsheet for Gun Info
- Thread starter dwstinge
- Start date
- Status
dogtown tom
Member
DoubleTapDrew
Member
GunSafe works good and is free. Keep a backup copy somewhere else in case of fire/computer theft.
Nugilum
Member
I'll PM you with a general version of what I use. You can't post spreadsheets here.
230RN
2A was "political" when it was first adopted.
I've just got a list. Gun, caliber, sn, attachments (scope, sling, etc) modifications, alterations, distinguishing characteristics, history,etc. Easy to add to, edit, delete, and very flexible.
And I can be as verbose as I want.
I have a shortcut to it on my desktop, so if something occurs to me at any old odd time, I just click and type.
However, I am thinking of putting it on a flash drive and taking it off the computer itself, even though it's not on my C:\ drive, along with other sensitive information.
I send copies to my sons if there are any changes.
And I can be as verbose as I want.
I have a shortcut to it on my desktop, so if something occurs to me at any old odd time, I just click and type.
However, I am thinking of putting it on a flash drive and taking it off the computer itself, even though it's not on my C:\ drive, along with other sensitive information.
I send copies to my sons if there are any changes.
Kind of Blued
Member
Microsoft Excel and analytical people go together incredibly well. I use it to record every gun I own, including date purchased, purchase price, MSRP, where I bought it, the caliber, serial number, who I want it to go to if I die, identifying markings, etc, etc. I've actually included everything of value that I own, or anything which includes a serial number. Of course, my laptop is included in the spreadsheet, so the file is e-mailed to myself every time I update it. I'll also print a hard copy or two and put those in a couple places.
Now if you want to talk about nerding out with Excel, I also have an Excel "program" which rate guns on how good they would be as carry guns. I have 30 or so fields with a certain number of points assigned to each, and I input the data of a particular gun and the program calculates a percentile for me.
I also have a program which I use to keep track of certain rare guns that sell (or fail to sell) on GunBroker. Buy-it-Now prices, reserve prices, bids, bidder names, winning bidders names, whether the original box and grips were included, condition etc. are all recorded. This gives me a good idea of what discontinued models are selling for in today's market, and what factors effect the price.
I have more time and skills than I do money.
Now if you want to talk about nerding out with Excel, I also have an Excel "program" which rate guns on how good they would be as carry guns. I have 30 or so fields with a certain number of points assigned to each, and I input the data of a particular gun and the program calculates a percentile for me.
I also have a program which I use to keep track of certain rare guns that sell (or fail to sell) on GunBroker. Buy-it-Now prices, reserve prices, bids, bidder names, winning bidders names, whether the original box and grips were included, condition etc. are all recorded. This gives me a good idea of what discontinued models are selling for in today's market, and what factors effect the price.
I have more time and skills than I do money.
czarjl
Member
This is my list... well at least part of it.
I have it in Excel and I e-mail my self a password protected copy. That way if I need the info I have it somewhere other than in my computer or the printed copy with all my other paper work (if I lose everthing I still have my list to cry over).
I have it in Excel and I e-mail my self a password protected copy. That way if I need the info I have it somewhere other than in my computer or the printed copy with all my other paper work (if I lose everthing I still have my list to cry over).
Attachments
If you want to use an Excel file but don't have or want M$ Office, grab a copy of OpenOffice. It's free, and compatible with Office files. I've pretty much dumped Office on all our machines.
dirt_j00
Member
cbrgator - to answer your question: go here - http://www.somanyroads.org/gunsafe/, then look at #1 toward the bottom. I think that is what you need.
Here are the fields I use on my excel .xls to keep up with my firearms:
Type,Make,Model,Caliber,Finish,Stock,Serial Number,Notes
and for scopes:
Make, Model, Model Number
Including the price you paid for it could be helpful too...think I'll borrow that idea!
Here are the fields I use on my excel .xls to keep up with my firearms:
Type,Make,Model,Caliber,Finish,Stock,Serial Number,Notes
and for scopes:
Make, Model, Model Number
Including the price you paid for it could be helpful too...think I'll borrow that idea!
Duke of Doubt
member
- Joined
- Dec 29, 2008
- Messages
- 2,863
dwstinge: "I like the idea of emailing myself a spreadsheet."
As a survivor, many years ago, of the Big Sux ... seek counselling, my young friend.
As a survivor, many years ago, of the Big Sux ... seek counselling, my young friend.
Sav .250
Member
I`ve got pictures of mine with all information on the back.
Duke of Doubt
member
- Joined
- Dec 29, 2008
- Messages
- 2,863
Sav .250: "I`ve got pictures of mine with all information on the back."
Circles, arrows, paragraphs on the back of each one explaining what each one was and how it was to be used as evidence against you?
Unwise.
Circles, arrows, paragraphs on the back of each one explaining what each one was and how it was to be used as evidence against you?
Unwise.
I have scanned images of the original receipts for all my guns, and save them to a USB memory stick. Just put them all in one dedicated folder. I also have the same folder on my hard drive. Since the scanner arbitrarily assigns the document title as an alphanumeric designation, I simply change that to whatever I like. This works fine for me, but then, I only have five guns.
Duke of Doubt
member
- Joined
- Dec 29, 2008
- Messages
- 2,863
TimRB; "Tin foil hat chafing a bit today Duke?"
Not really. Suppose a loved one allegedly stole one of your guns, allegedly used it allegedly to shoot her not-so-alleged rapist and batterer and, of all things, the alleged weapon somehow was recovered near the scene. Your home is searched. No report of the stolen gun has ever been filed. Whether any record of said gun is found in searches of computer hard drives or discs is a direct function of your tinfoil hat quotient, I imagine.
Yes, that pretty much happened to a family member of a client (elsewhere, elsewhen).
Not really. Suppose a loved one allegedly stole one of your guns, allegedly used it allegedly to shoot her not-so-alleged rapist and batterer and, of all things, the alleged weapon somehow was recovered near the scene. Your home is searched. No report of the stolen gun has ever been filed. Whether any record of said gun is found in searches of computer hard drives or discs is a direct function of your tinfoil hat quotient, I imagine.
Yes, that pretty much happened to a family member of a client (elsewhere, elsewhen).
knockonit
Member
gunsafe
the program has a edit portion for every section, go to main menu, pick manufacture, then scroll down alphabet , go to top menu click on new and add name, easy as one two three.
I have quite a collection and use this, if you're concerned about the tin foil aspect, put it on a flash drive, or like I did, I put it on a flash drive (two) and a disc, which I put in safe deposit box.
It is a great program and the best is its free to download.
I no longer have to itemize my stuff for insurance reasons, the fact that I have it serialized, pictured and detail description is enough for the leeches.
good luck with it, was a boon to me.
rj
the program has a edit portion for every section, go to main menu, pick manufacture, then scroll down alphabet , go to top menu click on new and add name, easy as one two three.
I have quite a collection and use this, if you're concerned about the tin foil aspect, put it on a flash drive, or like I did, I put it on a flash drive (two) and a disc, which I put in safe deposit box.
It is a great program and the best is its free to download.
I no longer have to itemize my stuff for insurance reasons, the fact that I have it serialized, pictured and detail description is enough for the leeches.
good luck with it, was a boon to me.
rj
Duke of Doubt
member
- Joined
- Dec 29, 2008
- Messages
- 2,863
TimRB: "How about this: Suppose your gun is stolen. The police recover one just like it, and ask you what the serial number of your gun is. You say "I dunno." The police then say "Sorry, we can't help you.""
Sounds good to me. Like the girl all over me last night, I don't know where that gun has been, now.
Sounds good to me. Like the girl all over me last night, I don't know where that gun has been, now.
boondockcrain
Member
All I get when I download is a search screen ???
Duke of Doubt
member
- Joined
- Dec 29, 2008
- Messages
- 2,863
statelineblues
Member
No, I think Duke was just having an Arlo Guthrie moment....
"I had to pay $50.00 and pick up the trash."
Last edited:
- Status