berettaprofessor
Member
As I was looking through my reloading log, it occurred to me that I could use the data to make a better way to choose a Lee Pro Auto-Disk cavity size for a given load than the volume measure density chart supplied by Lee. I simply charted out a number of loads where I had used a specific cavity and obtained a charge weight to get a chart like that below, demonstrating that charge weight and volume is a linear relationship:
Best of all, you can use the trendlines and equation functions in Excel to get an equation and predict any cavity necessary for that powder. The formula for CFE Pistol, listed on the chart above, is y=13.812x -0.3323. If I knew I wanted a CFE Pistol load of 6.2 grains, for instance, I could simply plug that into the equation above as "y", making the predicted cavity needed, or "x", = 0.473. Yes, I know that there is no 0.47 Lee cavity on any disk, but now I know that the 0.46 cavity will be as close as I can get.
The equation for W231, for those who want it, is y=11.467X -0.2417.
Now I'm left wondering why Lee doesn't just provide these linear equations, instead of the volume measure density figures that never seem to be accurate enough to give me the right cavity first.
Best of all, you can use the trendlines and equation functions in Excel to get an equation and predict any cavity necessary for that powder. The formula for CFE Pistol, listed on the chart above, is y=13.812x -0.3323. If I knew I wanted a CFE Pistol load of 6.2 grains, for instance, I could simply plug that into the equation above as "y", making the predicted cavity needed, or "x", = 0.473. Yes, I know that there is no 0.47 Lee cavity on any disk, but now I know that the 0.46 cavity will be as close as I can get.
The equation for W231, for those who want it, is y=11.467X -0.2417.
Now I'm left wondering why Lee doesn't just provide these linear equations, instead of the volume measure density figures that never seem to be accurate enough to give me the right cavity first.