Long Range Hunting Online Magazine


Go Back   Long Range Hunting Online Magazine > Rifles, Reloading, Optics, Equipment > Rifles, Bullets, Barrels and Ballistics


Reply

Free Recoil calculation spreadsheet

 
LinkBack Thread Tools Display Modes
  #1  
Old 11-13-2006, 06:45 PM
PUBLISHER
 
Join Date: May 2001
Posts: 5,852
Free Recoil calculation spreadsheet

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.
Attached Files
File Type: xls RECOIL.XLS (35.0 KB, 408 views)
__________________


Long Range Hunting Rifles

Long Range Rifles, LLC - Ready To Ship

Components and assembly by LRH Sponsors

Last edited by Len Backus; 02-01-2008 at 07:23 AM.
Reply With Quote
  #2  
Old 12-24-2008, 11:56 AM
Bronze Member
 
Join Date: Nov 2005
Posts: 41
Re: Free Recoil calculation spreadsheet

Very cool.
Reply With Quote
  #3  
Old 02-22-2009, 12:19 AM
Gold Member
 
Join Date: Oct 2007
Location: Patagonia Mountains, Arizona
Posts: 754
Re: Free Recoil calculation spreadsheet

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.
.
Reply With Quote
  #4  
Old 03-08-2009, 01:40 AM
Junior Member
 
Join Date: Feb 2009
Posts: 8
Re: Free Recoil calculation spreadsheet

Thanks
Reply With Quote
  #5  
Old 04-14-2010, 05:55 AM
PUBLISHER
 
Join Date: May 2001
Posts: 5,852
Re: Free Recoil calculation spreadsheet

Quote:
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.
__________________


Long Range Hunting Rifles

Long Range Rifles, LLC - Ready To Ship

Components and assembly by LRH Sponsors
Reply With Quote
  #6  
Old 05-21-2010, 09:40 AM
Bronze Member
 
Join Date: Dec 2007
Location: NC
Posts: 73
Re: Free Recoil calculation spreadsheet

Mr. Backus,

I have a simple chart I made in excel that I feel maybe helpful to a few folks. Would you be interested in posting it as an attachment? It is just a RPM calculation chart that I used to "help" determine if bullets that stablize in one barrel will do so in another. Just let me know how to proceed.

Thank You,
Shane
Reply With Quote
  #7  
Old 06-04-2010, 03:30 PM
Junior Member
 
Join Date: May 2010
Posts: 8
Re: Free Recoil calculation spreadsheet

How big is the difference in recoil between different powders (fast burning vs slow burning).
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes


Similar Threads for: Free Recoil calculation spreadsheet
Thread Thread Starter Forum Replies Last Post
Spreadsheet for reloading Mike6158 Reloading 33 04-08-2014 01:10 PM
Free recoil vs hard hold grinnergetter The Basics, Starting Out 10 05-21-2009 07:36 AM
Free Recoil Zero Shift Rymart Long Range Hunting & Shooting 17 10-07-2008 11:15 AM
Free recoil kcebcj The Basics, Starting Out 2 03-25-2008 07:41 PM
Dave King & Spreadsheet Michael Eichele Rifles, Bullets, Barrels and Ballistics 3 05-17-2003 11:16 PM

Current Poll
Do you archery hunt for elk?
YES - 29.94%
47 Votes
NO - 54.78%
86 Votes
Not yet, but I plan to. - 15.29%
24 Votes
Total Votes: 157
You may not vote on this poll.

All times are GMT -5. The time now is 05:01 AM.


Powered by vBulletin ©2000 - 2014, Jelsoft Enterprises Ltd.
Content Management Powered by vBadvanced CMPS
All content ©2010-2014 Long Range Hunting, LLC