I wanted to be able to compare various handgun loads by muzzle energy and determine a "benchmark" for each caliber in regards to power.
Note: I am not a handloader... all of this is for off the self loads anyone can order or buy at a store.
Not that it really matters, this is just for fun and not scientific and most likely full of holes. to keep it simple I compared only muzzle energy (ft lbs) and selected calibers of my interest. I know not all things are equal... barrel length, bullet weight etc but the idea is that for whatever caliber I might be interested in I'd have an average benchmark in ft lbs of muzzle energy. My sampling data is not consistent... calibers that I shoot I took as many as over 20 load sample data. Other loads that I don't shoot but I find interesting I took only as little as 3 data samples to get an average. I know its not consistent but really, this takes a lot of time to sit and copy paste info from manufacturers websites.
I put it all in a spreadsheet. I'm not a spreadsheet guru so I simply manually added up all the data sample muzzle energys for each caliber and divided the total by the sample amounts for the average and manually put that in another sheet for comparison (shown below). Then I sorted the Total Average column buy low to high. I thought the results interesting so then I made another column and typed in only the average of only the top 3 most powerful loads for each caliber.... (I ran out of time for some...)
Note: I am not a handloader... all of this is for off the self loads anyone can order or buy at a store.
Not that it really matters, this is just for fun and not scientific and most likely full of holes. to keep it simple I compared only muzzle energy (ft lbs) and selected calibers of my interest. I know not all things are equal... barrel length, bullet weight etc but the idea is that for whatever caliber I might be interested in I'd have an average benchmark in ft lbs of muzzle energy. My sampling data is not consistent... calibers that I shoot I took as many as over 20 load sample data. Other loads that I don't shoot but I find interesting I took only as little as 3 data samples to get an average. I know its not consistent but really, this takes a lot of time to sit and copy paste info from manufacturers websites.
I put it all in a spreadsheet. I'm not a spreadsheet guru so I simply manually added up all the data sample muzzle energys for each caliber and divided the total by the sample amounts for the average and manually put that in another sheet for comparison (shown below). Then I sorted the Total Average column buy low to high. I thought the results interesting so then I made another column and typed in only the average of only the top 3 most powerful loads for each caliber.... (I ran out of time for some...)