Armory Sponsor
Posted: 12/27/2013 4:50:10 AM EDT
|
Searching around for some innovative solutions for keeping inventory of reloading components and ammo. I am short on space so I have components stored in serveral different places. I've started a spreadsheet of what I have so I have a better picture if where I stand. Do any of you have a customized spreadsheet or software to track your inventory? Do you keep track of partial powder? Projectiles by the 100? How about brass in different stages of processing?
I'm thinking of splitting my reloads for pistol into lots of 100 and inventory that way completed anmo. Per 20 for rifles and per 50 for carbines. Seperate and keep in zipper type bags. What do you all do here? |
|
I keep a spreadsheet with prices I paid so I can track cost per round.
The rest is way way way too anal retentive for me. But I do powdercoat cast boolits, and trim pistol brass so i'm not here to judge. 
I keep mine organized in my garage so I can do a quick visual check and see what i'm low on. I turned my garage into a climate controlled reloading den. It's not done but i'm getting there. I don't have much problem running low. I set a certain amount in the budget every month that goes towards reloading no matter what. In the 2 years i've been reloading i've compiled a lot of material. EDIT - I keep all ammo in mtm plastic ammo cans so I know within 1000 rounds of what I have and don't have. I label the can with the recipe, date, and est round count. I also keep a master list of what guns like that round and approximate velocity/grouping from each gun. |
|
I keep a log of every bullet I make just to have a history. Everyone should do that.
I also keep an excel spreadsheet with all the primers, powder and bullets I have as well as the amounts. When I make a batch of bullets I just go to the spreadsheet and reduce the amount of each component. This file is saved on Dropbox, which I have on my phone and can check anytime I'm in a store that has a component I think I may need. For the powder just to the 7000 grains per pound conversion and you will be able to track each pound down to the last 10 or so rounds. |
|
I probably should do a spreadsheet LOL, been at this for almost 30 years, have 40+ sets of dies and shelving rack full of coffee cans with brass separated by at least caliber some broken down farther.
Problem is I would need to hire a secretary to keep the damn thing up to date.
|
|
The spreadsheet would be worth your time if you have to leave the topic for months at a time.
When I get sent out and come back after a long assignment, it is easy to loose track of inventory. If the last 10 years has taught lessons, it should be how yearly cycles can get trumped by politics and tragedies to have an effect on availability of our supplies. A moment to update your inventory helps you when you have to make opportunistic decisions on buying quantities of reloading supplies. If you are in some place far from home, and you catch an email notice or post about availability, you don't have to scramble to decide if you pull the trigger on a purchase. |
|
Quoted:
Rangelog, to me, seems like a good way to tell the NSA what you own. Quoted:
Quoted:
RANGELOG.com Online service can store that info and info about your firearms as well, but there's a annual fee. Rangelog, to me, seems like a good way to tell the NSA what you own. We are watching you. Nothing to see here. Move along. |
|
I created a excel spreadsheet to keep track of all of my ammunition and reloading supplies. I am anal about keeping detailed records because it helps me to make buying decisions so I don't end up with too much or too little of any component.
I have "in process" areas next to available brass and available bullets. I have a projections of what reloading needs to be done which helps me to plan what to reload. I have brass areas with 1x fired, 2x fired, etc to keep track of the brass being used. I have a completed ammunition section so I know what is available to shoot. I keep track of my handgun and rifle magazines, loaded or unloaded, and I take inventory of all ammunition and components once or twice per year. Also, it helps to have costs so I know what I paid and how much I have invested in ammunition and supplies. The spreadsheet would prove to be very useful if I kicked the bucket so my wife could easily determine the value if she wanted to sell any components or any of the factory ammunition. I have the completed, reloaded ammunition section clearly labeled not for resale on the spreadsheet. I keep an updated copy on a USB drive and a printed copy in the safe with other important records. The spreadsheet is always available to be revised if I see something that might work better, and it has been a bit of a process to get it where I have it now. It was a little time consuming to organize, but it is a great resource to have at my fingertips. |
|
I kept a pretty complex spread sheet for a few years, no benefit to me for the amount of work required. I now keep a printed log on a clip board in the reloading room and even then I only use it to track bulk items, once an 8lb keg is opened I consider it consumed and write it off, same thing with 1k projectile lots and primers.
My spread sheet recorded lot numbers on everything, when I reloaded batches that data auto populated to print labels with a random generated unique serial number. The summary sheet had hot links to the component data, price, date purchased, lot number etc. I don't think i have the file any longer, i shot all the loaded ammo documented so no longer needed it. Now my overall solution is anything but intelligent, i buy at least twice the amount i think i need and i think i need more than i actually do... plus i trip/navigate over the shit enough that I inadvertently take inventory often. |
|
I have an excel sheet of loaded rounds by caliber that calculates total rounds at the bottom. A competition with myself is to see how high I can get that number; that number is my lil secret tho...
On that workbook I also have a worksheet of components by caliber, primer type and number, powder type and rough poundage, and rough brass numbers. If I'm at a fun store or fun show I don't have to remember what to buy, I can pull it up on my phone from my computer thru the program Tonido and see if I am low on a certain component. Speaking of spreadsheets, keep one of all your guns and serial numbers. In case one is ever stolen etc. |
|
Quoted:
I have an excel sheet of loaded rounds by caliber that calculates total rounds at the bottom. A competition with myself is to see how high I can get that number; that number is my lil secret tho... On that workbook I also have a worksheet of components by caliber, primer type and number, powder type and rough poundage, and rough brass numbers. If I'm at a fun store or fun show I don't have to remember what to buy, I can pull it up on my phone from my computer thru the program Tonido and see if I am low on a certain component. Speaking of spreadsheets, keep one of all your guns and serial numbers. In case one is ever stolen etc. +1 to a Serial # sheet, make sure you list options & accessories with the piece which is all there in case shit happens. I have the original price paid and approx. replacement price column; along with date of mfr, caliber, type, etc. The list grows. |
|
I have been experimenting with Reloader's Reference.
It is a program/database that I stumbled onto on this site. Reloader's Reference |
|
Quoted:
I have been experimenting with Reloader's Reference. It is a program/database that I stumbled onto on this site. Reloader's Reference Interesting, I'll have to check this out. I started myself a spreadsheet to keep track of components. I haven't put together a list of reloads yet. |
Armory Sponsor