Armory Sponsor
Posted: 12/17/2015 4:39:26 PM EDT
|
It's cold and snowy here today so I've been updating some information on the computer. One of the things I wanted to do was make a spreadsheet that shows my different loads so I set it up by pistol and rifle, then by caliber, and then by bullet type/weight. Then I added the powder, charge weight, primer, brass, crimp, and OAL I've developed for each load. I knew I handloaded 7 pistol and 9 rifle calibers and I have a lot of bullet types, powders, brass, and primers but I didn't realize how many combinations I keep up with. Pistol: First by Caliber, then a line for each bullet with the 'recipe' including - Powder, Charge Weight, Primer, Brass Manufacturer, and Loaded OAL. Under each bullet line I'm listed the chrono data I have for that cartridge. (I don't have chrono data on all of them so I have 'homework' for this summer.) Rifle: First by Caliber, then a line for each bullet with the 'recipe' including - Powder, Charge Weight, Primer, Brass Manufacturer, Trim Length, and Loaded OAL. Under each bullet line I've listed the chrono data I have for that cartridge. It turns out that I load 26 different bullet types for my 7 Pistol calibers and load 22 different rifle bullet types for my 9 Rifle calibers. That means I make up 48 unique loads for my firearms; each with a unique set of primers, powder, trim lengths, brass, and OALs. No wonder my spreadsheet is considerably larger than I thought it would be! |
|
Quoted: I'm impressed I have wanted to do than for ages. Any chance of sharing your spreadsheet? Vince While I could give you the format, I don't feel that it's a good idea to take someone's load data and just use it instead of working up safe and accurate loads for your firearms. A couple of examples why this isn't a good idea are as follows: First - I have a load for my ARs using 68grn Hornady HPBT bullets and TAC powder. I handload these rounds for 5 different 1:9 Twist, 5.56 NATO and/or .223 Wylde chambered firearms we own. We don't own any .223 chambered firearms. My 68grn Hornady HPBT handloads at 25.9grns of TAC are just under the SAAMI max charge for 5.56 NATO and/or .223 Wylde chambered firearm at 26.0grns but are far above the SAAMI max load for a .223 chambered platform at 24.4grns. My loads are safe in all 5 of the firearms I load for but wouldn't be for those with .223 chambers. Second - I've worked up loads for my specific firearms, including calibers for custom firearms I developed in 2004 (my custom Glock G20/21L). These loads are safe and accurate in my firearms with my components, at my altitude (6000 - 9000 feet asl), with my conditions (arid climate). There is no guarantee that they would work well in other firearms, at other altitudes, in other climates in other parts of the country. There is also no guarantee that they all would be safe, reliable, or useful in other firearms as they are custom made for mine. As a handloader, each of us is responsible to work up loads that are safe, reliable, and accurate in our own weapons. So, in my opening post I mentioned the columns of data I've collected and told you that the rows are set up first by pistol or rifle, then by caliber, and finally by bullet. So I may have 4 different 40s&w loads because I use 4 different bullets. Some may use the same powder and primer and some may not. It depends upon what you've done. |
I keep a spreadsheet too.. Thanks for reminding me.. I have a lot of updates to do. I think I have doubled my calibers since I last updated it. 
I got the format from another forum. Forget where... I normally also spend time comparing my loads to manufactured loads to see how much money I am saving. I reloaded 200 338 Lapua rounds last weekend. Each would cost $5-6 each (Over $1K) if I had to buy them. I obviously spent considerably less. Amazing savings in reloading sometimes.. But I do spend a ton in hardware (fixed costs). 
|
|
Quoted:
While I could give you the format, I don't feel that it's a good idea to take someone's load data and just use it instead of working up safe and accurate loads for your firearms. A couple of examples why this isn't a good idea are as follows: You misunderstood, I would just like the spreadsheet without YOUR load data on it. Vinc |
|
Quoted:
You misunderstood, I would just like the spreadsheet without YOUR load data on it. Vinc Quoted:
Quoted:
While I could give you the format, I don't feel that it's a good idea to take someone's load data and just use it instead of working up safe and accurate loads for your firearms. A couple of examples why this isn't a good idea are as follows: You misunderstood, I would just like the spreadsheet without YOUR load data on it. Vinc Yeah, COSteve. If you don't mind sharing, I would make good use of it also. IM us if you can. |
|
Mediafire is free, and is a good site to host downloads for say PDF and the likes.
I use it all the time for when I want to share files on the forums. Hence, http://www.mediafire.com/view/oaa02e1ku2ivnwl/2005_Steering_lock_diagram.pdf |
|
Quoted:
All who want a copy of this simple Excel Spreadsheet just email me and I'll attach a copy of the file. I can't add an attachment to an IM and the spreadsheet has a calculation in it so you want the excel file. Sent out: 1 Request sent. Have you ever looked into gunmanager (http://www.gunmanager.com/)? It is pitched as a gun database, where you can keep a record of all your firearms and accessories for insurance purposes, but it also has a section devoted to reloading. Basically you keep an inventory of all your components and then when you make a load you "buy" the ammo from your inventory. I haven't had a chance to mess with it yet but I thought it might be something you were interested in. I too reload for about a dozen or so rifle/pistols and have trouble keeping up with all my components.. Hell, I'm only 30 too. I can't imagine what my stockpile will look like when I'm retired at 70ish with 50 years worth of reloading/hording. |
|
My Wife has been helping Me to build a spreadsheet for storing all My gun info and serial #'s and a inventory of reloading components.
For My own use, and insurance purposes. Think about it, there is a lot of money in a reloading room. Could You remember it all in the event of a fire, or theft. |
|
Quoted: My Wife has been helping Me to build a spreadsheet for storing all My gun info and serial #'s and a inventory of reloading components. For My own use, and insurance purposes. Think about it, there is a lot of money in a reloading room. Could You remember it all in the event of a fire, or theft. Yep, a necessary item for sure. In addition, I and my son have a joint firearms agreement that lists everything we have and states that they are jointly owned. That if one of use either can't or doesn't want to own them, they instantly revert to the sole ownership of the other. Also, in the event of death, they also instantly revert to sole ownership. The firearms are listed in a dated attachment by make, model, s/n, and all options, additions are listed. As any new firearm is added, it's included. Further, pictures are included. There is another dated attachment listing all reloading equipment and components and it is also updated as necessary. Works for ownership as well as in the event of loss. Both, me, my son, and a trusted neighbor have a copy of the agreement and attachments. |
I need to add pictures, one thing I still need to do. Also need to do whatever, in case I terminate, so it all will go to My Wife. I don't know if ownership of firearms would automatically go to Her. We got the new BS laws in Washington.
At 23, I'm not turning what I got over to My son at that age. |
|
What really surprise my guests is that there are so many nice handloads that allow you to shoot centerfire cheaper than you can rimfire.
38spl HBWC loads will use 1lb powder for 2000rnds. 380 is near the same 9mm just a bit less yield per lb. and cast /gas checked 223 can be loaded near the same using Red or Green Dot powder. This is all day fun with bolt guns. cast / downloaded brass seems to last forever and when the neck splits you just chop the case and make 300 Blackout or 45 win mag from 308 or -06 brass. |
|
What really surprise my guests is that there are so many nice handloads that allow you to shoot centerfire cheaper than you can rimfire.
38spl HBWC loads will use 1lb powder for 2000rnds. 380 is near the same 9mm just a bit less yield per lb. and cast /gas checked 223 can be loaded near the same using Red or Green Dot powder. This is all day fun with bolt guns. cast / downloaded brass seems to last forever and when the neck splits you just chop the case and make 300 Blackout or 45 win mag from 308 or -06 brass. |
|
I really need to work up a spreadsheet for both my gun inventory and reload data.
I've always been bad on the reloading data. Usually just a post it in the box with the loads. This, of course, leads to a constant cycle of load development when I inevitably lose that post it! |
|
Quoted:
Request sent. Have you ever looked into gunmanager (http://www.gunmanager.com/)? It is pitched as a gun database, where you can keep a record of all your firearms and accessories for insurance purposes, but it also has a section devoted to reloading. Basically you keep an inventory of all your components and then when you make a load you "buy" the ammo from your inventory. I haven't had a chance to mess with it yet but I thought it might be something you were interested in. I too reload for about a dozen or so rifle/pistols and have trouble keeping up with all my components.. Hell, I'm only 30 too. I can't imagine what my stockpile will look like when I'm retired at 70ish with 50 years worth of reloading/hording. Quoted:
Quoted:
All who want a copy of this simple Excel Spreadsheet just email me and I'll attach a copy of the file. I can't add an attachment to an IM and the spreadsheet has a calculation in it so you want the excel file. Sent out: 1 Request sent. Have you ever looked into gunmanager (http://www.gunmanager.com/)? It is pitched as a gun database, where you can keep a record of all your firearms and accessories for insurance purposes, but it also has a section devoted to reloading. Basically you keep an inventory of all your components and then when you make a load you "buy" the ammo from your inventory. I haven't had a chance to mess with it yet but I thought it might be something you were interested in. I too reload for about a dozen or so rifle/pistols and have trouble keeping up with all my components.. Hell, I'm only 30 too. I can't imagine what my stockpile will look like when I'm retired at 70ish with 50 years worth of reloading/hording. request sent. this program looks interesting...i might try it out |
|
Quoted: I really need to work up a spreadsheet for both my gun inventory and reload data. I've always been bad on the reloading data. Usually just a post it in the box with the loads. This, of course, leads to a constant cycle of load development when I inevitably lose that post it! An inventory spreadsheet is simple to make. Just a column for type (Pistols, Rifles, Shotguns, etc). Under each type, a heading by caliber, i.e. 22lr, 9mm, 45acp, etc., and then a row for each firearm. Next to it a column for manufacturer and model, then one for s/n and date mfg, then one for month and year acquired, then a larger one for the description including any accessories such as grips, sling, mags, optics, etc. Date it and keep it updated as you add accessories or new arms. It's simple. Example under .223/5.56 Rifles:
No, I'm not going to make templates available for those. You are all smart enough to decide what you want and do it yourself. |
|
CO Steve-
You reload because, like all of us that post here, you are REAL genuine bada$$ with caveman DNA. And yet, miraculously, we can build a spreadsheet and will select our favorite reloading equipment based on whether it is red, green, or blue. Except us 1050 owners are stuck with generic slate grey dammit- I have learned to live with that due to the fact that Chuck Norris builds them. I keep manual records of components, and need to do smilar to the spreadsheet idea so I can more easily identify what components I need more of. |
|
Well, it turns out I didn't tell the truth in my original post when I mentioned I had 26 pistol and 22 rifle loads. Turns out I was looking through a folder on my computer and found a old version of the previous spreadsheet I thought I threw out. It has some other loads I was thinking about trying again so I've added them to my spreadsheet and now I note that I have information on 45 different pistol loads for 7 calibers and 38 different rifle loads for 9 calibers. The reason there are so many different pistol loads is that included in them is information on 357mag and 45 Colt loads that I use in my leverguns as they have different charges and measured velocities. Some calibers like my 300 Savage 99, I only have two bullet/powder combos for only 1 rifle but others like my .223/5.56 data I have many bullet/powder combos for 5 different rifles. As all 5 have different barrel lengths, and 4 are semi-auto and one is a bolt gun, all produce different velocities. These are just the loads that produced the best groups so I've tried many, many more to get to this list. Some loads took me 6 tries to find a sweet spot for a particular rifle. This old spreadsheet even had specific data on my chrono trips including date and time, weather conditions including temperature at the range, number of rds in the string, and my SD and ES numbers. Now I know why I've shot so many rounds. I spend a ton of time and money behind my chrono trying different loads! |
Armory Sponsor