GlockTalk.com
Home Forums Classifieds Blogs Today's Posts Search Social Groups



  
SIGN-UP
Notices

Glock Talk
Welcome To The Glock Talk Forums.
Reply
 
Thread Tools Display Modes
Old 01-08-2005, 09:57   #1
357glocker
Senior Member
 
357glocker's Avatar
 
Join Date: Oct 2002
Location: NE
Posts: 2,251
microsoft Excel formula needed

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.
__________________
Teamwork- A few harmless flakes working together can unleash an avalanche of destruction.

Losing- If at first you don't succeed, failure may be your style.
357glocker is offline   Reply With Quote
Old 01-08-2005, 10:29   #2
Sinister Angel
I'd Hit It!
 
Join Date: Oct 2004
Location: Traverse City, Michigan
Posts: 1,433
Send a message via AIM to Sinister Angel Send a message via Yahoo to Sinister Angel
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
Sinister Angel is offline   Reply With Quote
Old 01-08-2005, 10:43   #3
357glocker
Senior Member
 
357glocker's Avatar
 
Join Date: Oct 2002
Location: NE
Posts: 2,251
Thanks, that did it for me!
__________________
Teamwork- A few harmless flakes working together can unleash an avalanche of destruction.

Losing- If at first you don't succeed, failure may be your style.
357glocker is offline   Reply With Quote
Old 01-08-2005, 11:08   #4
Sinister Angel
I'd Hit It!
 
Join Date: Oct 2004
Location: Traverse City, Michigan
Posts: 1,433
Send a message via AIM to Sinister Angel Send a message via Yahoo to Sinister Angel
Quote:
Originally posted by 357glocker
Thanks, that did it for me!
Excellent
Sinister Angel is offline   Reply With Quote
Old 01-08-2005, 11:10   #5
357glocker
Senior Member
 
357glocker's Avatar
 
Join Date: Oct 2002
Location: NE
Posts: 2,251
I even found the min and max formulas to use for the extreme spread formula;c

Btw if anybody would like a copy of the spreadsheet I can email it to them.
__________________
Teamwork- A few harmless flakes working together can unleash an avalanche of destruction.

Losing- If at first you don't succeed, failure may be your style.
357glocker is offline   Reply With Quote
Old 01-08-2005, 12:21   #6
Sinister Angel
I'd Hit It!
 
Join Date: Oct 2004
Location: Traverse City, Michigan
Posts: 1,433
Send a message via AIM to Sinister Angel Send a message via Yahoo to Sinister Angel
Quote:
Originally posted by 357glocker
I even found the min and max formulas to use for the extreme spread formula;c

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
Sinister Angel is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump




All times are GMT -6. The time now is 06:07.



Homepage
FAQ
Forums
Calendar
Advertise
Gallery
GT Wiki
GT Blogs
Social Groups
Classifieds


Users Currently Online: 979
287 Members
692 Guests

Most users ever online: 2,244
Nov 11, 2013 at 11:42