microsoft Excel formula needed [Archive] - Glock Talk

PDA

View Full Version : microsoft Excel formula needed


357glocker
01-08-2005, 10:57
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.

Sinister Angel
01-08-2005, 11:29
Stick the deviation formula in the ABS() function to tell it to give you the absolut value (always positive)

http://www.meadinkent.co.uk/xltextabs.htm

357glocker
01-08-2005, 11:43
Thanks, that did it for me!:)

Sinister Angel
01-08-2005, 12:08
Originally posted by 357glocker
Thanks, that did it for me!:)

Excellent :)

357glocker
01-08-2005, 12:10
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.

Sinister Angel
01-08-2005, 13:21
Originally posted by 357glocker
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.

I try to avoid statistics like the plague ;f