• This Forum is for adults 18 years of age or over. By continuing to use this Forum you are confirming that you are 18 or older. No content shall be viewed by any person under 18 in California.

How to chart load development results

Just came back from my first ever load development with some (hopefully useful) data. My problem is organizing it in a format that allows me to pinpoint possible nodes. Any tool recommendations? I am trying to massage the numbers in excel, but am having a hard time wrapping my head around it.

24.5gr24.7gr24.9gr25.1gr25.3gr25.5gr25.7gr25.9gr26.1gr26.3gr26.5gr26.7gr26.9gr27.1gr27.3gr27.5gr27.7gr
FPS1
2380.4​
2399.9​
2402.6​
2438.6​
2445.3​
2471.9​
2491.2​
2497.2​
2518.2​
2528.6​
2541.3​
2567.8​
2576.5​
2603.7​
2603.7​
2626.3​
2638.2​
FPS2
2372.0​
2390.0​
2409.5​
2433.4​
2446.0​
2465.1​
2495.8​
2494.3​
2527.9​
2531.2​
2542.2​
2555.1​
2556.9​
2586.4​
2614.5​
2629.4​
2646.1​
FPS3
2370.6​
2399.6​
2412.3​
2440.8​
2448.2​
2465.4​
2478.7​
2495.1​
2536.7​
2528.4​
2550.9​
2562.4​
2595.9​
2596.2​
2614.9​
2624.0​
2636.0​
 
To sort of combine the advice of all others mentioned above, I'll usually do a load ladder with 3 shots on a fresh bullseye for each load. Once I move along to a more focused charge range I'll step to 5 shot groups. For the OP, something that I've found beneficial is writing out the load and range data on the target and saving a picture of it in my spreadsheet. It really helps me recall where I was headed since I have reloaders ADHD and almost never finish one work up at a time. It also helps remember when your accuracy node and sd maybe don't align perfectly. I made some address labels to make recording data less time consuming. Sometimes I'll also save pictures of the fired cases or anything else that might be relevant in the spreadsheet.
 

Attachments

  • Screenshot_20240420-033609.png
    Screenshot_20240420-033609.png
    958.7 KB · Views: 25
Just came back from my first ever load development with some (hopefully useful) data. My problem is organizing it in a format that allows me to pinpoint possible nodes. Any tool recommendations? I am trying to massage the numbers in excel, but am having a hard time wrapping my head around it.

24.5gr24.7gr24.9gr25.1gr25.3gr25.5gr25.7gr25.9gr26.1gr26.3gr26.5gr26.7gr26.9gr27.1gr27.3gr27.5gr27.7gr
FPS1
2380.4​
2399.9​
2402.6​
2438.6​
2445.3​
2471.9​
2491.2​
2497.2​
2518.2​
2528.6​
2541.3​
2567.8​
2576.5​
2603.7​
2603.7​
2626.3​
2638.2​
FPS2
2372.0​
2390.0​
2409.5​
2433.4​
2446.0​
2465.1​
2495.8​
2494.3​
2527.9​
2531.2​
2542.2​
2555.1​
2556.9​
2586.4​
2614.5​
2629.4​
2646.1​
FPS3
2370.6​
2399.6​
2412.3​
2440.8​
2448.2​
2465.4​
2478.7​
2495.1​
2536.7​
2528.4​
2550.9​
2562.4​
2595.9​
2596.2​
2614.9​
2624.0​
2636.0​
What brand chronograph are you using ?
Some have apps to help foremat data .
 
View attachment 1547800

ETA: I hit the post button without seeing the plots that @Straightshooter1 posted above. The data has to be import formatted from ASCI characters into numerical, then it can be plotted. If you just import into Excel, it comes in without numerical values and looks like zeros.
Very interesting!!! I've read grafts and charts most of my life!!! Where the 3 shot velocity spread is small (almost making a single dot on the graft), they occur where the slope of the average line approaches Zero and lay in the valley of the 2 adjacent powder charges!!! Looks like the node is between 26.3 and 26.5 since the average line segment there is the flatest!!! I would run 5 shot strings at 26.0, 26.2, 26.4, 26.6 and 26.8. Record velocities and check target grouping!!! The secret to precision reloading is consistency in powder charge vs velocity spread which is proportional to the consistent pressures!!!
BILL
 
Last edited:
I don't have a clue what these graphs show that is usefull.
Neither do I.
To politely coin a phrase from @Varminterror , chasing that rabbit won’t get you fed. The guys that shoot some of the smallest groups in the world just use a paper target to accomplish load development and only consult a chronograph as a side note.
 
Last edited:
Small sample size statistics can mislead you. The range of expected values for each powder charge in a 1-5 shot test at each charge will cover enough velocity that all of this will become a straight line over time. Most statistics require a sample size of 30 per data point to get a full picture of the possible distribution of the values. The pure physics of adding more propellant to the same case volume and not seeing a linear increase in velocity goes against intuition.

I used to look for flat spots or nodes but have gone to looking for minimum velocity needed for the bullet to perform at the distances required ( expansion for hunting loads, supersonic at 1k for target shooting etc. ) and the maximum load when pressure occurs. If a powder and bullet give me velocity in that range and are about 1.0 grain under pressure sign, I will look for group size and shape and then tweak with a jump test if one shows some promise. I am quicker now to try another powder or another bullet rather than hunting up and down for a charge weight and bullet seating depth and getting a good result one day and not so good the next with the same load.

The reality has shown that where I used to see flat spots are generally 80-90% max loads and these are the case fills that tend to work if a powder/ bullet combination will produce good results in your barrel.

All I am saying is what others have said .. let the target tell you what works. If it says it isn’t working, don’t waste components and barrel life making a silk purse out of a sows ear.
If it is … get a barrels life number of those components and enjoy shooting an accurate rifle.
 
I save and work on velocity and target info. 'On Target PC' is very helpful for group sizes and the ability to spot when the muzzle is in a quiescent period and grouping along a flatter part of the sine wave.
 

Attachments

  • LOAD.jpg
    LOAD.jpg
    147.7 KB · Views: 28
Very interesting!!! I've read grafts and charts most of my life!!! Where the 3 shot velocity spread is small (almost making a single dot on the graft), they occur where the slope of the average line approaches Zero and lay in the valley of the 2 adjacent powder charges!!! Looks like the node is between 26.3 and 26.5 since the average line segment there is the flatest!!! I would run 5 shot strings at 26.0, 26.2, 26.4, 26.6 and 26.8. Record velocities and check target grouping!!! The secret to precision reloading is consistency in powder charge vs velocity spread which is proportional to the consistent pressures!!!
BILL
Good point and I totally agree about the importance of "consistency in powder charge vs velocity spread", which the target tends to represent. Rather than graphs telling me about velocity consistency, it's velocity SD's that tell me which loads are the most consistent. Though the lowest SD's seldom coincide with the best groupings on paper, it is indeed ALL about consistency for every aspect.

If the slope of the average line is repeatable, then I'd say that approach to determining a "node" would certainly be valid. Once in a while one will find a couple that repeat, but always, the more one does the more one finds no consistency for that zero slope.

I always try to record velocities when target shooting, as the velocity data I collect only tells me how well I'm doing with my reloading. It's only the target that tells me which load is working and which isn't. Velocity data does help me with getting to the right barrel timing, especially when I have a good idea where I need to be with a particular barrel configuration, powder and projectile. Also, having plenty of velocity data helps with getting on target when long range shooting. :)
 
I don't have a clue what these graphs show that is usefull.
Neither do I.
To politely coin a phrase from @Varminterror , chasing that rabbit won’t get you fed. The guys that shoot some of the smallest groups in the world just use a paper target to accomplish load development and only consult a chronograph as a side note.
See post #5 and #13 in this string.
After pointing out that the idea of using a chronograph to plot "velocity flat spots" was misguided advice...
The OP was shown that his chrono data could still be turned into useable data and the graph he requested.

Once several forum members inform a poster that they should check into the issues, it is time to move on.

The utility of a charge versus velocity plot is not for finding the optimum load, it is to cross check the load against expectations and predictions and then for adjusting internal ballistics models. As such, it is recommended that folks don't spend too many shots on wide velocity sweeps since it would waste a considerable amount of their resources on charge steps they would never use and then still require more.

It isn't possible to explain internal or external ballistics in a thread, nor can we teach one method of load development that can be used for everything, but we can say that dumping rounds over a chronograph to look for velocity flat spots is misguided. Then to be helpful, we try to explain how to process the data into the graph as requested. Carry on.
 
gas post #5 and #13 in this string.
After pointing out that the idea of using a chronograph to plot "velocity flat spots" was misguided advice...
The OP was shown that his chrono data could still be turned into useable data and the graph he requested.

Once several forum members inform a poster that they should check into the issues, it is time to move on.

The utility of a charge versus velocity plot is not for finding the optimum load, it is to cross check the load against expectations and predictions and then for adjusting internal ballistics models. As such, it is recommended that folks don't spend too many shots on wide velocity sweeps since it would waste a considerable amount of their resources on charge steps they would never use and then still require more.

It isn't possible to explain internal or external ballistics in a thread, nor can we teach one method of load development that can be used for everything, but we can say that dumping rounds over a chronograph to look for velocity flat spots is misguided. Then to be helpful, we try to explain how to process the data into the graph as requested. Carry on.
I'm sorry!!! I did get off of the subject of plotting and grafting of the chrony data!!! The plotting of that graft showed factors of load development that just stood out like a soar thumb!!! But, I said it looks like a node, didn't say it was the node!!! And yes, in my study of Statistics, a 3 shot string is not a good population!!! That is why I was suggesting a 5 shot string using the even numbered tenths of a grain!!! This could still lead to replication of the 1st test data!!! And I total agree that target groups are the final say!! I'm saying this an Engineer, we can use other tools to achieve that goal!!!

By the way, I do have 105 credit hours of pure applied science!!! Mostly in physics and mathematics next!!! Using calculus, I could find the min/max points, point of inflection, and critical point of the plotted graft!!! My study in Thermodynamics (the study of heat energy) is the closest study to understanding internal ballistics!!! Heat is the result of the combustion (explosion) of the powder!!
A firearm has about the same characteristics of a 4 cycle (non mechanically linked piston) engine that drives that bullet out of the barrel!!! Not the 2 cycle, diesel, or rotary engine of which I have studied in thermo!!!! I could set down and calculate the peak temperature at a given peak pressure!!! You would be amazed by the temp of that plasmatic gas!!!
 
Last edited:
RR posted;
Once several forum members inform a poster that they should check into the issues, it is time to move on…

Yet the thread continued in repetition, I suppose one of the good things about living in America is being able to reply on an open forum as did at least eleven members on this thread.

As long as the truth even lightheartedly is presented without being rude or insulting there shouldn’t be a problem presenting one’s view.
 
I save and work on velocity and target info. 'On Target PC' is very helpful for group sizes and the ability to spot when the muzzle is in a quiescent period and grouping along a flatter part of the sine wave.
The spread between a few similar loads is extreme. Doesn't make sense.
 
RR posted;
Once several forum members inform a poster that they should check into the issues, it is time to move on…

Yet the thread continued in repetition, I suppose one of the good things about living in America is being able to reply on an open forum as did at least eleven members on this thread.

As long as the truth even lightheartedly is presented without being rude or insulting there shouldn’t be a problem presenting one’s view.
I support that last line and hope you didn't think I was implying a problem with anyone else.

I am somewhat dyslexic and a horrible writer, so apologies if that sounded like it was directed outward. What I meant to say is I should move on, so it was meant to mean me not you or anyone else. Carry on.
 

Upgrades & Donations

This Forum's expenses are primarily paid by member contributions. You can upgrade your Forum membership in seconds. Gold and Silver members get unlimited FREE classifieds for one year. Gold members can upload custom avatars.


Click Upgrade Membership Button ABOVE to get Gold or Silver Status.

You can also donate any amount, large or small, with the button below. Include your Forum Name in the PayPal Notes field.


To DONATE by CHECK, or make a recurring donation, CLICK HERE to learn how.

Forum statistics

Threads
165,800
Messages
2,203,303
Members
79,110
Latest member
miles813
Back
Top