Free Recoil calculation spreadsheet

Discussion in 'Long Range Hunting & Shooting' started by Len Backus, Nov 13, 2006.

  1. Len Backus

    Len Backus Administrator Staff Member

    Messages:
    6,343
    Joined:
    May 2, 2001
    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:

    Last edited: Feb 1, 2008
  2. johndoe

    johndoe Active Member

    Messages:
    41
    Joined:
    Nov 11, 2005
    Very cool.
     

  3. LouBoyd

    LouBoyd Well-Known Member

    Messages:
    770
    Joined:
    Oct 15, 2007
    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.
    .
     
  4. frederick.208

    frederick.208 Member

    Messages:
    8
    Joined:
    Feb 28, 2009
    Thanks
     
  5. Len Backus

    Len Backus Administrator Staff Member

    Messages:
    6,343
    Joined:
    May 2, 2001
    Whatever. :):):)
     
  6. Bull45cal.

    Bull45cal. Well-Known Member

    Messages:
    77
    Joined:
    Dec 11, 2007
    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
     
  7. cdes29

    cdes29 Member

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

    Len Backus Administrator Staff Member

    Messages:
    6,343
    Joined:
    May 2, 2001
    Sorry, I don't know.
     
    Last edited: Jun 5, 2010
  9. cdes29

    cdes29 Member

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

    edwaj002 Active Member

    Messages:
    32
    Joined:
    Feb 3, 2009
    Thanks, will be fun to mess around with.
     
  11. Bowhunter7

    Bowhunter7 Active Member

    Messages:
    41
    Joined:
    Apr 16, 2014
    You guys are a bunch of PUSSYS!!!!! You cant handle recoil?
     
  12. Ron J

    Ron J Active Member

    Messages:
    44
    Joined:
    Sep 3, 2014
    Thank You for your work Len Backus.
     
  13. TracySes23

    TracySes23 Well-Known Member

    Messages:
    208
    Joined:
    Aug 16, 2012
    Says the bowhunter. :)