close
Long Range Hunting Online Magazine


Go Back   Long Range Hunting Online Magazine > Hunting > Long Range Hunting & Shooting

Long Range Hunting & Shooting Nightforce Optics

Reply

Free Recoil calculation spreadsheet

LinkBack Thread Tools Display Modes
  #1  
Unread 11-13-2006, 06:45 PM
PUBLISHER
 
Join Date: May 2001
Posts: 6,477
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 Rifles, LLC - Ready To Ship

.

Last edited by Len Backus; 02-01-2008 at 07:23 AM.
Reply With Quote
  •   #2  
    Unread 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  
    Unread 02-22-2009, 12:19 AM
    Gold Member
     
    Join Date: Oct 2007
    Location: Patagonia Mountains, Arizona
    Posts: 770
    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  
    Unread 03-08-2009, 01:40 AM
    Junior Member
     
    Join Date: Feb 2009
    Posts: 8
    Re: Free Recoil calculation spreadsheet

    Thanks
    Reply With Quote
      #5  
    Unread 04-14-2010, 05:55 AM
    PUBLISHER
     
    Join Date: May 2001
    Posts: 6,477
    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 Rifles, LLC - Ready To Ship

    .
    Reply With Quote
      #6  
    Unread 05-21-2010, 09:40 AM
    Bronze Member
     
    Join Date: Dec 2007
    Location: NC
    Posts: 77
    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  
    Unread 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 39 06-05-2016 05:24 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 & Ballistics 3 05-17-2003 11:16 PM


    All times are GMT -5. The time now is 03:23 PM.


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