close
Long Range Hunting Online Magazine


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

Rifles, Bullets, Barrels & Ballistics Applied Ballistics

Reply

Spreadsheet to Calculate Barrel Life

LinkBack Thread Tools Display Modes
  #1  
Unread 08-13-2013, 07:00 AM
Platinum Member
 
Join Date: Dec 2005
Posts: 2,483
Spreadsheet to Calculate Barrel Life

Found this Excel spreadsheet on calculating barrel life. It's pretty interesting in that it uses popular powder's heat potential in its formulas.

It's a SWAP; Scientific Wild Ass Prediction; not an exact number of rounds a barrel will last. But it does show that some cartridges wear out barrels faster than others. It doesn't provide input for how accurate someone shoots rifles nor the quality of the barrel and the ammo used in any accuracy test they conduct. It's based on pin drivers; they shoot more accurate than tack drivers. Most folks know that a military service grade semiautomatic rifle that averages 1 to 2 MOA accuracy at 100 yards will have a much longer barrel life than a pin driving competition rifle that averages under 1/4 MOA at 100 yards.

One thing that's sometimes held in contention is wear caused by the rate of fire. Some top level barrel makers that feel rapid fire with normal pressure rounds doesn't wear out barrels as slow fire use of high pressure rounds. Others think otherwise.

Excel Formula Predicts Useful Barrel Life within AccurateShooter.com
Reply With Quote
  •   #2  
    Unread 08-13-2013, 12:59 PM
    Platinum Member
     
    Join Date: May 2008
    Location: South of Canada and North of Wyoming
    Posts: 6,068
    Re: Spreadsheet to Calculate Barrel Life

    Interesting

    I can't get the powder heat potential chart to open very far.

    Looks like a 7mm burning 85 gr of average powder @ 60ksi is getting less the 700 rounds of life.
    __________________
    - Mark

    You will never know how much it has cost my generation to preserve your freedom. I hope you make good use of it.
    ~ John Quincy Adams
    Reply With Quote

      #3  
    Unread 08-13-2013, 01:44 PM
    Platinum Member
     
    Join Date: Mar 2012
    Location: ND
    Posts: 2,801
    Re: Spreadsheet to Calculate Barrel Life

    Quote:
    Originally Posted by MontanaRifleman View Post

    Looks like a 7mm burning 85 gr of average powder @ 60ksi is getting less the 700 rounds of life.
    __________________

    I'm 18
    "Firearms are second only to the Constitution in importance; they are the peoples' liberty's teeth."
    ~George Washington

    "The only advantage a light rifle has is weight, all other advantages go to the heavy rifle."
    ~ JE Custom

    Biggest fail of 2014 so far... http://www.longrangehunting.com/foru...ea-ftf-128972/

    My guess on W3P .308 230 Grain Bullet: G1 .740-.755
    Reply With Quote
      #4  
    Unread 08-13-2013, 03:16 PM
    Platinum Member
     
    Join Date: Dec 2005
    Posts: 2,483
    Re: Spreadsheet to Calculate Barrel Life

    Quote:
    Originally Posted by MontanaRifleman View Post
    I can't get the powder heat potential chart to open very far.

    Looks like a 7mm burning 85 gr of average powder @ 60ksi is getting less the 700 rounds of life
    Neither could I see all the powder data, but I think they are all in there; they just can be scrolled up to see what the lower part of the data table has. If Mike comes across this thread, maybe he'll comment on that. What I do is remember or write down the powder potential, type it in then let it run.

    After a good friend using Sierra Bullets' ballistic tech personal 7mm Rem Mag rifle set a record in the scope sight 1000 yard match at the 1970 Nationals, a lot of folks had to get one to shoot long range, Few understood why good accuracy dropped off bad in a hurry after 700 to 800 rounds. My own first long range match rifle was a .264 Win. Mag that lasted 640 rounds burning 72(?) grains of H870 under Norma 139-gr. nickel plated match bullets.

    Last edited by Bart B; 08-13-2013 at 05:22 PM.
    Reply With Quote
      #5  
    Unread 08-13-2013, 03:20 PM
    Platinum Member
     
    Join Date: May 2008
    Location: South of Canada and North of Wyoming
    Posts: 6,068
    Re: Spreadsheet to Calculate Barrel Life

    It looks to me like that chart is bigger. It would be nice to know those other powder heat potentials.
    __________________
    - Mark

    You will never know how much it has cost my generation to preserve your freedom. I hope you make good use of it.
    ~ John Quincy Adams
    Reply With Quote
      #6  
    Unread 08-13-2013, 06:27 PM
    Platinum Member
     
    Join Date: Aug 2003
    Location: NC, oceanfront
    Posts: 4,057
    Re: Spreadsheet to Calculate Barrel Life

    I wrote this a long time ago. That old version is less than perfect and I've asked 6mmbr.com to remove it as they've also posted newer versions. But the internet is sometimes unforgiving on getting rid of stuff.

    If I had a way to post my latest here I would. If you'd like a copy email for it:
    Mcrawford@ec.rr.com

    I did a huge amount of research to form this and Bart is accurate in his assessment of it.
    It does pass many many tests, as I have verified over the years.
    The powder heat potential and pressure comes from QuickLoad.
    Latest version calculates a line in the sand for shot rate, and I've dropped moly adjustment as nobody uses moly anymore.

    Barrel life here is 'accurate barrel life'. That is a point where best accuracy, if reached, begins to drop(rapidly). Since most folks never actually achieve best accuracy from a barrel, most folks are late to see it's potential go bye-bye. That is, if the best you expect is 1moa from a 6.5x284, well then you may get 1moa FOREVER. If you reach 1/4moa with one, accept that you'll kiss that goodbye at ~1200rnds.
    In contrast, BR shooters see it like a light switch was flipped.
    If you group shoot quickly, your barrel's potential leaves quicker. If you shoot higher pressures, more powder, hotter powder, most overbore cartridges, barrel life is reduced. There is a price for everything.

    One area that is not accounted for, as the data doesn't yet exist, is barrel life after Melonite treatment. This seems the best extension of life I've ever read about, potentially doubling even BR shooting barrel life.
    Reply With Quote
      #7  
    Unread 08-13-2013, 06:39 PM
    Platinum Member
     
    Join Date: May 2008
    Location: South of Canada and North of Wyoming
    Posts: 6,068
    Re: Spreadsheet to Calculate Barrel Life

    email sent
    __________________
    - Mark

    You will never know how much it has cost my generation to preserve your freedom. I hope you make good use of it.
    ~ John Quincy Adams
    Reply With Quote
    Reply

    Bookmarks

    Thread Tools
    Display Modes



    All times are GMT -5. The time now is 10:45 AM.


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