AWorthyOpponent
Member
I see a lot of posts that talk about what kind of guns you have, how much ammo you have, etc… I think that many people don’t like to keep a record of the guns they own, because they are afraid “Big Brother” is going to find it and come after them. While I am concerned about this, slightly, I know that it isn’t likely, and don’t let it bother me. If you want a list to keep track of your firearms, you’re more than welcome to use the one I have created. This Excel 2007 Spreadsheet keeps track of Firearms owned, Firearms you have sold, Firearms you wish to buy, Accessories you own, Accessories you wish to own, and Amounts of Ammunition you have, versus how much you can store in ammo cans you have, or whatever. Something like this could come in handy if your firearms are ever stolen, or destroyed in a fire, or even lost on a boating accident.
If you want, you can check it out, by downloading it here
First and Foremost, if you download this, it is a .zip compressed file, so you must first decompress the file. To do this, Right Click on the file you downloaded, and click on “Extract”.
If you actually intend on using the file to keep an accurate list of your firearms, I would recommend you add some kind of security to the document. Office 2007 makes it easy to password protect a document. (see the first image to locate where to do this)
On the first tab, under the section “Type” I have it setup to put “Pistol”, “Shotgun”, “Rifle”, and “Full Auto”. If you do this, you will be able to use the chart on the last tab, “Charts”, to see what portions of your firearms are which.
In the “Ammo” tab, it is set up so that you can put any type of ammunition in the “Caliber” section (ie 9mm Luger, 7.62x39, 12 Gauge, etc…), as well as the amount of rounds you have. There is a chart under the “Charts” tab that covers this as well, giving you a visual depiction of how much ammo you currently have (Blue Bar), in comparison to how much ammunition you have the ability to store (RED BAR). This helps me visually keep track of how much ammo I have, needed to buy, and project costs for myself. I use a calculator to find my “cost per shot” to estimate prices. The “Rounds to Buy”, “Cost to Replenish”, and “Current Value” are calculated based upon the other information given in that tab.
If you intend to use the charts on the “Charts” tab, you will have to click on one of the charts, and press “Alt+F5”. This will update all of the charts with the updated data after you make any changes. If you do not do this when you look at the chart, you will not be viewing the up to date data.
How many of us keep a detailed list of Firearms, Ammo, and Accessories we own?
If you want, you can check it out, by downloading it here
First and Foremost, if you download this, it is a .zip compressed file, so you must first decompress the file. To do this, Right Click on the file you downloaded, and click on “Extract”.
If you actually intend on using the file to keep an accurate list of your firearms, I would recommend you add some kind of security to the document. Office 2007 makes it easy to password protect a document. (see the first image to locate where to do this)
On the first tab, under the section “Type” I have it setup to put “Pistol”, “Shotgun”, “Rifle”, and “Full Auto”. If you do this, you will be able to use the chart on the last tab, “Charts”, to see what portions of your firearms are which.
In the “Ammo” tab, it is set up so that you can put any type of ammunition in the “Caliber” section (ie 9mm Luger, 7.62x39, 12 Gauge, etc…), as well as the amount of rounds you have. There is a chart under the “Charts” tab that covers this as well, giving you a visual depiction of how much ammo you currently have (Blue Bar), in comparison to how much ammunition you have the ability to store (RED BAR). This helps me visually keep track of how much ammo I have, needed to buy, and project costs for myself. I use a calculator to find my “cost per shot” to estimate prices. The “Rounds to Buy”, “Cost to Replenish”, and “Current Value” are calculated based upon the other information given in that tab.
If you intend to use the charts on the “Charts” tab, you will have to click on one of the charts, and press “Alt+F5”. This will update all of the charts with the updated data after you make any changes. If you do not do this when you look at the chart, you will not be viewing the up to date data.
How many of us keep a detailed list of Firearms, Ammo, and Accessories we own?