ryleecarr2006
Member
Good idea!
Spreadsheet for reloading
- Thread starter Mike6158
- Start date
Help Support Long Range Hunting Forum
I spread my load data all over hell. Email, cloud, usb drives. Don't want to lose it.
bonie
Well-Known Member
I spread the sheets of test load targets out on the bench and go from there.
Thanks. I have a new version for powder testing. It calculates Avg Velocity, ES, and SD from up to 5 shot strings then calculates the difference between shots (which highlights a node if it's there). Unfortunately I haven't been able to upload it (I'll try to attach it to this post). It worked. I had to archive the files but the attached Zip file has a Mac and Windows versions in it (Numbers and Excel). The blue numbers are calculated so don't put anything there or you will break it.
I finally got to try the spreadsheet out with a suppressed and supersonic load for a pair of 8.6BLK AR10's. Both were first time loads (by me) for the rifles. I approached "with caution" lol and it shows with the load data. I'll reload the rounds based on the data I picked up. Velocity as from a Garmin. My LabRadar (yes I still have one) trigger isn't reliable on my AR's (the barrel is under the hand guard). The Garmin did great so I'll be using it more. Takeaways:
(1) Based on the data I can see that I approached load development "carefully". Subs were very sub and supers were barely super after the 2nd group.
(2) Not a fan of AA1660. It's dirty. I could even tell which case had been fired with it by the smell coming off of the annealer. The next test will be with something else. I could try N110 but I'd like to have more case fill.
(3) There are some oddities in the velocity groups. The last 4 in the supers (2nd sheet) are out of order. I'm not sure how that happened but that's what it looks like to me. The last group of the subs, 9, is a sighter load. The load notes I keep at my bench say I loaded 8 groups not 9. The powder charge for sighters is not correct. I decided to lower the sighters until I knew what the Barnes bullet was going to do. The sheet says TTSX and I loaded a .338 280gr. LRX. Good thing I keep notes as I load :/
(4) The last four columns of the Delta calc have the wrong formula in them :/ Just copy a good value over each box and it'll be correct. When I have access to Excel again I'll post a correction for those that aren't familiar with Excel. For me, the sheet pointed out some things that I did wrong or documented wrong. The next test should give me more useful data.
Subs
Supers
(1) Based on the data I can see that I approached load development "carefully". Subs were very sub and supers were barely super after the 2nd group.
(2) Not a fan of AA1660. It's dirty. I could even tell which case had been fired with it by the smell coming off of the annealer. The next test will be with something else. I could try N110 but I'd like to have more case fill.
(3) There are some oddities in the velocity groups. The last 4 in the supers (2nd sheet) are out of order. I'm not sure how that happened but that's what it looks like to me. The last group of the subs, 9, is a sighter load. The load notes I keep at my bench say I loaded 8 groups not 9. The powder charge for sighters is not correct. I decided to lower the sighters until I knew what the Barnes bullet was going to do. The sheet says TTSX and I loaded a .338 280gr. LRX. Good thing I keep notes as I load :/
(4) The last four columns of the Delta calc have the wrong formula in them :/ Just copy a good value over each box and it'll be correct. When I have access to Excel again I'll post a correction for those that aren't familiar with Excel. For me, the sheet pointed out some things that I did wrong or documented wrong. The next test should give me more useful data.
Subs
Supers
Hugnot
Well-Known Member
Here is one of my latest efforts:
I am working up loads with the 62 gr. .224 H ELDVX - fyne accuracy with 7.7 twist @ just under 3,600 fps with VN 540 but failure with 9 twist .223.
73 ELDM at 1.04 inches, Sg 1.68, 9 twist at 2850, .223 shoots real good. The length diff between .224 62 ELDMVT & .224 73 ELDM is only .01 inches, like 10 thou. Plastic tip lengths same.
.223 - 62 ELDMVT at 1.05 inches, Sg 1.33, 9 twist at 2950, .223, 3 foot groups, not good - this indicates the Miller process is not working with this bullet. I suspect the reason is a wide separation between center of mass & center of pressure. About 1/4 of the inner bullet is void. A 1.33 Sg would indicate marginal stability with good groups but slight degradation of ballistics - not realizing BC. Possibly the lead core might be replaced core with tin/copper sinter mix like the Barnes Varmint Grenade & bullet shortened slightly and plastic tip.
.22-.250 - 62 ELDMVT at 1.05 inches, Sg 1.92, 7.7 twist, G7 BC of 1.99 is great - RPM's at 336,623 - just under 3,600 fps, no indications of failure. Able to hit 3 inch steel consistently but slowly at 300, using 1 MOA elevation from 200 yard zero. Hornady sez 8 twist on box. Happy!
This gotta be a killer rodent bullet up to 500 from my 7.7 twist .22-.250's.
I am working up loads with the 62 gr. .224 H ELDVX - fyne accuracy with 7.7 twist @ just under 3,600 fps with VN 540 but failure with 9 twist .223.
73 ELDM at 1.04 inches, Sg 1.68, 9 twist at 2850, .223 shoots real good. The length diff between .224 62 ELDMVT & .224 73 ELDM is only .01 inches, like 10 thou. Plastic tip lengths same.
.223 - 62 ELDMVT at 1.05 inches, Sg 1.33, 9 twist at 2950, .223, 3 foot groups, not good - this indicates the Miller process is not working with this bullet. I suspect the reason is a wide separation between center of mass & center of pressure. About 1/4 of the inner bullet is void. A 1.33 Sg would indicate marginal stability with good groups but slight degradation of ballistics - not realizing BC. Possibly the lead core might be replaced core with tin/copper sinter mix like the Barnes Varmint Grenade & bullet shortened slightly and plastic tip.
.22-.250 - 62 ELDMVT at 1.05 inches, Sg 1.92, 7.7 twist, G7 BC of 1.99 is great - RPM's at 336,623 - just under 3,600 fps, no indications of failure. Able to hit 3 inch steel consistently but slowly at 300, using 1 MOA elevation from 200 yard zero. Hornady sez 8 twist on box. Happy!
This gotta be a killer rodent bullet up to 500 from my 7.7 twist .22-.250's.
Last edited:
Headshothills
Member
Thanks for sharing
