Free Recoil calculation spreadsheet

Len Backus

Administrator
Staff member
Joined
May 2, 2001
Messages
6,703
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,703
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,703
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
742
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

Nightforce has great tracking capabilities, they are rugged, a bunch of elevation, holds zero forever, and reticles are designed for long range shooting. So if you are looking to shoot long distances constantly, then you need a scope that can take the abuse. -- gilmillan1


Culture Of Excellence At Nightforce Optics
By Len Backus

A high level of quality both in production and in service. Read More


Nightforce is such a solid combo of reticle, available elevation, glass that is good enough to shoot at the longest range you can dial. Nightforce has bullet proof construction that can handle the incidental horse rolling or some other rodeo action. -- bigngreen


Nightforce ATACR Scope Review
By Jeff Brozovich

The new NightForce ATACR is for sure a top choice for any long range shooter. Read More


The total package. Nightforce is the best I have used as far as turret feel and solid detents. I have never had one that didn't track right on and always return to zero. Nightforce NXS is the best value for everything I need. -- Broz


Nightforce Velocity 1000 Reticle Review
By Scott Shreve

I think Nightforce knocked it outta the park with this reticle! Read More

NightForce


Top