close

Privacy guaranteed - Your email is not shared with anyone.

Welcome to Glock Talk

Why should YOU join our Glock forum?

  • Converse with other Glock Enthusiasts
  • Learn about the latest hunting products
  • Becoming a member is FREE and EASY

If you consider yourself a beginner or an avid shooter, the Glock Talk community is your place to discuss self defense, concealed carry, reloading, target shooting, and all things Glock.

microsoft Excel formula needed

Discussion in 'Tech Talk' started by 357glocker, Jan 8, 2005.

  1. 357glocker

    357glocker

    1,029
    0
    Oct 28, 2002
    NE
    I'm setting up a spreadsheet so I can calculate all my ballistic information from my chronograph. The formula I need help with is to calculate the deviation from the average velocity. I'm trying to use the subtraction formula but depending on the actual veloctiy of the shot it may come up a negative value. I need them to all show a positive value because the avg. deviation formula is the sum of differences of the actual velocity from the average velocity.
    Ex: Avg vel.=550.3

    Actual velocity: 568.6 Deviation would be 18.3
    538.0 deviation would technically be -12.3 but I need it to show +12.3

    Hopefully I explained this right.
     
  2. Sinister Angel

    Sinister Angel I'd Hit It!

    252
    0
    Oct 11, 2004
    Traverse City, Michigan

  3. Sinister Angel

    Sinister Angel I'd Hit It!

    252
    0
    Oct 11, 2004
    Traverse City, Michigan
    Excellent :)
     
  4. 357glocker

    357glocker

    1,029
    0
    Oct 28, 2002
    NE
    I even found the min and max formulas to use for the extreme spread formula;c :cool:

    Btw if anybody would like a copy of the spreadsheet I can email it to them.
     
  5. Sinister Angel

    Sinister Angel I'd Hit It!

    252
    0
    Oct 11, 2004
    Traverse City, Michigan
    I try to avoid statistics like the plague ;f