Free Recoil calculation spreadsheet

Len Backus

Administrator
Staff member
Joined
May 2, 2001
Messages
6,743
I created this Excel file several years ago.

Input the weight of the rifle, bullet and powder charge, add the bullet velocity, stir well and it spits out the ft-lbs of recoil.

Click on the link below to download the Excel file.
 

Attachments

Last edited:

LouBoyd

Well-Known Member
Joined
Oct 15, 2007
Messages
770
Location
Patagonia Mountains, Arizona
There's not sufficient input information to determine the average velocity vector of the molecules of the propellant gas. Certainly barrel length, expansion ratio, propellant pressure (or temperature) and the effect of a brake (if any) imake a difference in recoil even though all the parameters used in this spreadsheet are held constant.

Some programs (like Quickload) give one recoil emergy calculation as the bullet passes the crown and another value after the propellant has exited the barrel. The first number is the same wiith or without a brake. The second can be more or less with a brake and can be considerably different. Quickload however doesn't calculate the effect of a brake. Brake manufactures dont give performace data which can be used in calculations, at least none that I've seen.

This spreadsheet appears to be the result of empirically fitting of measured data from tests on typical rifles without brakes. For that I expect it works fairly well.
.
 

Len Backus

Administrator
Staff member
Joined
May 2, 2001
Messages
6,743
There's not sufficient input information to determine the average velocity vector of the molecules of the propellant gas. Certainly barrel length, expansion ratio, propellant pressure (or temperature) and the effect of a brake (if any) imake a difference in recoil even though all the parameters used in this spreadsheet are held constant.
Whatever. :):):)
 

cdes29

Member
Joined
May 30, 2010
Messages
8
How big is the difference in recoil between different powders (fast burning vs slow burning).
 

Len Backus

Administrator
Staff member
Joined
May 2, 2001
Messages
6,743
How big is the difference in recoil between different powders (fast burning vs slow burning).
Sorry, I don't know.
 
Last edited:

cdes29

Member
Joined
May 30, 2010
Messages
8
Thanks anyway. It is still a good tool to compare different calibers and loads.
 

Bowhunter7

Active Member
Joined
Apr 16, 2014
Messages
41
Location
New Mexico
I created this Excel file several years ago.

Input the weight of the rifle, bullet and powder charge, add the bullet velocity, stir well and it spits out the ft-lbs of recoil.

Click on the link below to download the Excel file.
You guys are a bunch of PUSSYS!!!!! You cant handle recoil?
 

Wizard of Oz

Active Member
Joined
Dec 28, 2016
Messages
42
I created this Excel file several years ago.

Input the weight of the rifle, bullet and powder charge, add the bullet velocity, stir well and it spits out the ft-lbs of recoil.

Click on the link below to download the Excel file.
Thanks Len, very much appreciated. Cheers Tom
 

Clark

Well-Known Member
Joined
Oct 19, 2006
Messages
748
Lou Boyd?
I have been doing gun forums since before the www on the old usenet, rec.guns. back in 1994.
That is back when intelligent people were on the internet.

My work with recoil was mainly to figure out that the threshold of pain is near 20 psi.
The free recoil must be applied to the area of the recoil pad and the time to compress it.
 

Trending threads

Recent Posts

Top