I'm amazed at how much time I can waste when I really set my mind to it! This is for you
@steve white, even though I know you were more interested in seat of the pants, real-world experience and/or opinion. Also for you
@Alistair because I appreciate the theory discussion in your initial effort; I think you were on to something. I was able to build the efficiency calculation database AND get my work done today. My ground rules were:
- Use all Hodgdon powders using their load data (for consistency); assume that Hodgdon's data is accurate, that there is no "agenda" behind their data, and that their max loads represent the highest powder charge without going over SAAMI pressure limit
- Use as many hunting calibers as possible from the well-known ones to some that I've heard mentioned on this site from time to time; throw in a couple of benchrest carts for comparison
- Only allow carts where the test data indicates a 24-inch barrel (again, for consistency); this left out several Weatherby carts and the 308 Norma Mag (26") and the 300 Savage (22")
- Don't pick and choose powders/bullets/weights; pull EVERYTHING from the load data and let the spreadsheet sort it out (removes bias and lets us find the needle in the haystack); there are 3,636 loads represented.
Here are the 73 cartridges I selected for the database. It is easy to add others if anyone has a request (must be in Hodgdon's load data to qualify):
View attachment 732923
And here are the 24 Hodgdon powders represented:
View attachment 732924
All I have time for tonight is highlights after the overall sort. This is energy efficiency, so
(Bullet weight x velocity^2)/450436 = KE/Powder Charge = Ft.lb/grain = Efficiency
- Various loadings from 5 cartridges took the Top 26 spots: 460WBY, 458WM, 405Win, 45-70, 308Win. Notice three of those are straightwall, so whoever was first to suggest that is a winner
- The most energy efficient load of all was the 460WBY pushing a 600gr Barnes RN to 2439fps with 104gr of H4350 (E=76.2)
- The most energy efficient 308Win was a 210gr Berger VLD Hunter at 2276fps over 34.7gr of Benchmark
- The top 64 spots were held by 8 cartridges; joining the Top 5 were the 338-06, 338RCM, and 416 Rem Mag
- In last overall place with E=27.0 was the 30-40 Krag trying to push a 100gr Hornady SP with 51gr of H4350 to 2492fps
When vacation starts at the end of the week, I'll be able to sort by caliber, powder, cartridge, bullet, etc. and answer specific questions if anybody cares (probably not). It's a Google Sheet so I don't mind sharing if anyone is interested (probably not).