Quantcast

6.5 Guys Excel Statistical Load Development

Discussion in 'Competition Shooting' started by _Robert, Nov 15, 2019.

  1. _Robert

    _Robert Member

    Joined:
    Oct 12, 2019
    Messages:
    19
    I'm learning precision rifle shooting techniques; shooting form & load development.

    OCW vs Statistics

    I watched 6.5 guys YouTube video describing their Excel Stats tool that can predict a good load from Chrono data alone. The prediction is based on the load that demonstrates velocity flat spot & low ES/SD

    I shot 50 rds, 5 shots with 10 powder loads varying by 0.2gr using a Magnetospeed to generate velocity data. I also evaluated each target to calculate MOA.

    Surprise! 6.5 guys statistical prediction matched my lowest MOA Target.

    I'm a believer in their method.

    Ruger American Predator, .223, FC cases, CCI primers, H335, Hornady 62gr BTHP, 2.25 COAL
     
  2. Nature Boy

    Nature Boy Member

    Joined:
    Apr 21, 2015
    Messages:
    4,327
    Can you show your targets and data?
     
  3. horsemen61

    horsemen61 Member

    Joined:
    Oct 20, 2011
    Messages:
    4,275

    Agreed
     
  4. _Robert

    _Robert Member

    Joined:
    Oct 12, 2019
    Messages:
    19
  5. _Robert

    _Robert Member

    Joined:
    Oct 12, 2019
    Messages:
    19
  6. _Robert

    _Robert Member

    Joined:
    Oct 12, 2019
    Messages:
    19
  7. _Robert

    _Robert Member

    Joined:
    Oct 12, 2019
    Messages:
    19
  8. _Robert

    _Robert Member

    Joined:
    Oct 12, 2019
    Messages:
    19
  9. _Robert

    _Robert Member

    Joined:
    Oct 12, 2019
    Messages:
    19
  10. _Robert

    _Robert Member

    Joined:
    Oct 12, 2019
    Messages:
    19
  11. _Robert

    _Robert Member

    Joined:
    Oct 12, 2019
    Messages:
    19
    Sorry for the delay!

    I've been a pistol shooter & pistol reloader for 20 yrs But;

    I recently bought a Ruger American Predator in 223 and am practicing shooting and reloading rifle at the same time.

    http://www.65guys.com/

    Have both a great YouTube channel and web page. Steve's software is available for download

    Their software predicts long range accuracy based on low ES.

    Long story short:

    62gr Hornady 2276C with 23.6gr H335 was predicted by the software to be a good load and it is.

    I was toying with seating depth with 0.010" from lands producing 0.95 MOA (avetage of 5 groups in the attachment)

    I ordered 500 new bullets, Hornady 68gr BTHP Match and I have 100 SMK 69gr

    I hope that the combination of: Improved loading skills, better bullets and rifle practice yields better groups.

    The groups were analyzed using OnTarget software

    1g.jpg
     
    Last edited: Nov 30, 2019
  12. _Robert

    _Robert Member

    Joined:
    Oct 12, 2019
    Messages:
    19
    Here's the 6.5 Guys YouTube:

     
  13. Varminterror

    Varminterror Member

    Joined:
    Jul 17, 2016
    Messages:
    6,855
    It’s just a pre-packaged tool to analyze Satterlee method data. Nice of them to package it for folks, but it appears a little clunkier than it could be, since they had to produce an input-only template which didn’t demand user functional manipulation. Takes about 2min to put together a similar curve from scratch in excel, I’ve done my last few on my phone while driving back from the range.
     
    _Robert likes this.
  14. _Robert

    _Robert Member

    Joined:
    Oct 12, 2019
    Messages:
    19
    "Clunky" Yes!

    Macro Enabled Excel won't run on my phone, tablet or Google Sheets

    I'll take your implied suggestion to create a sheet compatible with my portable devices.
     
  15. carnaby

    carnaby Member

    Joined:
    Feb 25, 2004
    Messages:
    1,375
    Location:
    Bellingham, WA
    Dubious at best. They fail to reject the null hypothesis:

    https://en.m.wikipedia.org/wiki/Null_hypothesis

    Until they have figured out how to determine a reasonable group size metric and its associated confidence intervals, the 6.5 guys conclusions are not supported by the data.

    Excel has the tools to do this, but 5-shot groups are not going to cut the mustard.
     
    JeffG likes this.
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice