brashboy

August 3, 2007, 01:24 AM

I don't know if anyone else shares this interest, but I spreadheeted ballistics info in Excel for a number of popular handgun calibers, both S/Auto and wheelgun. Here is what I included:

1) Bullet weight

2) Bullet type

3) Manufacturer

4) Barrel length

5) Velocity and energy data, both muzzle and 50-yards.

6) I calculated the drop-off in V and E at 50 yards

7) I calculated momentum = (Grains / 7000) x terminal velocity

Terminal Velocity was assumed to be at 50 yards

I know that momentum (foot pounds per second) is one of the most reliable indicators of stopping power, since it takes both bullet weight and terminal velocity into account. In close range SD situations, the terminal velocity point would be much closer (and therefore momentum higher), but that number would vary for each situation and is not standard in any event.

My goal was, basically, to compare realistic stopping power of different cartridges, a topic that gets a lot of ink on every gun forum. It accurately reflects the higher stopping power of .40 SW and .45 ACP, for example, compared to smaller cartridges, as noted in many other measures of stopping power. Shot placement and other factors are very important, too, but we all know that given identical shot placement, a .45 will be a better stopper than 9mm, for example (I shoot both, no flames, please). I'm not out to hawk or dismiss any caliber, just having fun. I'm thinking about adding the TKO (Pondoro Taylor knockdown) formula, too, but have assumed it will simply validate the better stopping power of bigger bullets + heavier weights. What do you think - would that be cool? Obviously, many calibers are left out, just ran out of gas.

Everyone is welcome to play with the spreadsheet - add, change, whatever. The base tables were taken from a gun magazine site site - I'm not even sure which one off the top of my head (probably G&A) - but I assume they are as accurate as any other ballistics information out there. I liked these because they incorporated both manufacturer and bullet type.

PROBLEM: The forum does not allow upload of an .xls file. Any ideas on how to post it?

Moderator: kindly move this to a better place, if this is not the right one. It seemed like the best bet.

1) Bullet weight

2) Bullet type

3) Manufacturer

4) Barrel length

5) Velocity and energy data, both muzzle and 50-yards.

6) I calculated the drop-off in V and E at 50 yards

7) I calculated momentum = (Grains / 7000) x terminal velocity

Terminal Velocity was assumed to be at 50 yards

I know that momentum (foot pounds per second) is one of the most reliable indicators of stopping power, since it takes both bullet weight and terminal velocity into account. In close range SD situations, the terminal velocity point would be much closer (and therefore momentum higher), but that number would vary for each situation and is not standard in any event.

My goal was, basically, to compare realistic stopping power of different cartridges, a topic that gets a lot of ink on every gun forum. It accurately reflects the higher stopping power of .40 SW and .45 ACP, for example, compared to smaller cartridges, as noted in many other measures of stopping power. Shot placement and other factors are very important, too, but we all know that given identical shot placement, a .45 will be a better stopper than 9mm, for example (I shoot both, no flames, please). I'm not out to hawk or dismiss any caliber, just having fun. I'm thinking about adding the TKO (Pondoro Taylor knockdown) formula, too, but have assumed it will simply validate the better stopping power of bigger bullets + heavier weights. What do you think - would that be cool? Obviously, many calibers are left out, just ran out of gas.

Everyone is welcome to play with the spreadsheet - add, change, whatever. The base tables were taken from a gun magazine site site - I'm not even sure which one off the top of my head (probably G&A) - but I assume they are as accurate as any other ballistics information out there. I liked these because they incorporated both manufacturer and bullet type.

PROBLEM: The forum does not allow upload of an .xls file. Any ideas on how to post it?

Moderator: kindly move this to a better place, if this is not the right one. It seemed like the best bet.