ࡱ>    !"#$%&'Root Entry 2(@Workbook IWksSSWorkBook=WksSSChart              + ) , *      $ D$          D D     `Sheet1   E  dMbP?_*+%&?'?(?)?"??M oU } } m} $}  } }  } } I EX@,@     @@@@@zq Enter up to 15 numeric Variations by column in the red-bordered cells. Leave unused cells blank. Group B  Group C Group D Group E Group F Group G Group H-$ V #1 =~ @~ F@~ F@~ @~ @~ `@~ #Г@-$ V #2 =~ @z@~ @~ @~ `t@~ H@~ @~ $ȓ@-$ V #3 =~ `z@~ F@~ F@~ @~  @~ @~ $@.% V #4 = ~ (z@~ @~ @~ @~ @~ 0@~ $t@.% V #5 = ~ @~ @~ F@~ A@~ `@~ $@.% V #6 = ~ @~ @~ @~ @$.% V #7 = ~ At@~ @~ F@~ @$. % V #8 = ~ @~ @~ @~  @ $. % V #9 = ~ @~ @~ @~ @ $. % V #10 = ~ z@~ F@~ @~ @ $. % V #11 = ~ @ $. % V #12 = ~ z@ $.% V #13 = ~ 8z@$.  \pMS Works Ba==:&%8X@"1Arial1Arial1Arial1Arial1Arial1 Arial1 Arial1 Arial1  Arial"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_) 0.00.0000.00000.000000.000000 0.00000000E+000.0E+00 0.000E+00 0.0000E+00 0.00000E+00 0.000000E+00 0.0000000E+001$#,##0.0_);($#,##0.0\)9$#,##0.000_);($#,##0.000\)=$#,##0.0000_);($#,##0.0000\)A$#,##0.00000_);($#,##0.00000\)E $#,##0.000000_);($#,##0.000000\)I"$#,##0.0000000_);($#,##0.0000000\) 0.0%0.000%0.0000%0.00000% 0.000000% 0.0000000%#,##0.0 #,##0.000 #,##0.0000 #,##0.00000 #,##0.000000 #,##0.0000000 d\-mmm\-yy mmmm d, yyyy m/d m/yy mmmm, yyyymmmm dd mmm mmmm dd dddd yy yyyy 00 000 000000000000000000000000000000#\ ?/2#\ ?/3#\ ?/4#\ ?/8#\ ?/10#\ ?/16#\ ?/32#\ ?/100=$#,##0.0_);[Red]\($#,##0.0\)E $#,##0.000_);[Red]\($#,##0.000\)I"$#,##0.0000_);[Red]\($#,##0.0000\)M$$#,##0.00000_);[Red]\($#,##0.00000\)Q&$#,##0.000000_);[Red]\($#,##0.000000\)U($#,##0.0000000_);[Red]\($#,##0.0000000\)9#,##0.0_);[Red]\(#,##0.0\)A#,##0.000_);[Red]\(#,##0.000\)E #,##0.0000_);[Red]\(#,##0.0000\)I"#,##0.00000_);[Red]\(#,##0.00000\)M$#,##0.000000_);[Red]\(#,##0.000000\)Q&#,##0.0000000_);[Red]\(#,##0.0000000\) #\ ??/???) #,##0_);( #,##0\)1 #,##0.0_);( #,##0.0\)5 #,##0.00_);( #,##0.00\)9 #,##0.000_);( #,##0.000\)= #,##0.0000_);( #,##0.0000\)A #,##0.00000_);( #,##0.00000\)E  #,##0.000000_);( #,##0.000000\)I" #,##0.0000000_);( #,##0.0000000\)5 #,##0_);[Red]\( #,##0\)= #,##0.0_);[Red]\( #,##0.0\)A #,##0.00_);[Red]\( #,##0.00\)E  #,##0.000_);[Red]\( #,##0.000\)I" #,##0.0000_);[Red]\( #,##0.0000\)M$ #,##0.00000_);[Red]\( #,##0.00000\)Q& #,##0.000000_);[Red]\( #,##0.000000\)U( #,##0.0000000_);[Red]\( #,##0.0000000\)  % V #14 = ~ @$.% V #15 = ~ @" V Sum =#@ %B#33333;|@ %B#fffff&|@ %B#@ %B#(@ %B#@ %B#@ %B  V Number =#.@ %B#$@ %B#$@ %B#$@ %B#@ %B#@ %B#@ %B" V Average = !az@ DD!(\•F@ DD!QF@ DD!zGut@ DD!(@ DD!D@ DD!fffff@ DD   ! V Average = !az@ DA!(\•F@ DA!QF@ DA!zGut@ DA!(@ DA!D@ DA!fffff@ DA    High V = #̼z@ %B#33333F@ %B#F@ %B#t@ %B#H@ %B#`@ %B#@ %B Low V =#(z@ %B#F@ %B#ffffffF@ %B#\t@ %B#@ %B#@ %B#t@ %BExtreme Spread =!"@ DD!? DD!? DD!fffff@ DD!&@ DD![@ DD!B@ DDStandard Deviation =#on9@ %B#Jmq%? %B#>Yd? %B#4P '? %B#4x3@ %B#kC@ %B#^ρ*@ %B @!`"`#$'@(,@)*+,-.1@2345679;<=>?@A%BC%D Standard Deviation = ! Q@ DA! V-? DA! Mb? DA! ^I +? DA! ?5^I@ DA! VC@ DA! n*@ DA! Average + 1 SD =$!ףp= z@$$ B$!-F@$$ B$!/$F@$$ B$!/݂t@$$ B$!5^I:@$$ B$! r@$$ B$!Cl@$$ B" Average - 1 SD =!"](:z@ DD !"$F@ DD !"~jtF@ DD !"V-gt@ DD !"ˡEs@ DD !";O@ DD !"A`Ѐ@ DD $# Average + 1 SD rounded =!#z@ D!A!#fffffF@ D!A!#F@ D!A!#33333t@ D!A!#fffff:@ D!A!#@ D!A!#@ D!A$$ Average - 1 SD rounded =!$9z@ D"A!$F@ D"A!$33333sF@ D"A!$ht@ D"A!$@ D"A!$@ D"A!$̀@ D"Ag'^ Taylor's Knockout formula = weight in grains * diameter in inches * velocity / 7000'''''''( Bullet #1( Bullet #2( Bullet #3(  Bullet #4( Bullet #5(  Bullet #6( Bullet #7) Bullet weight =~ )`z@~ )D@~ ) b@~ )p@~ )@_@~ )p@~ )#t@* Bullet diameter =*sh|??*y&1?*V-?*~jt?* +?*~jt?~ *$?+ Bullet velocity =~ +@~ +@@~ +@~ +D@~ +(@~ +D@~ +"@- Knockout value =,-6?@D)D*D+X,-Bh:;?D)D*D+X,-r$@D)D*D+X,-$NO.8@D)D*D+X,-F(@D)D*D+X,-$NO.8@D)D*D+X,-"><@D)D*D+X . Rounded KO value =!.(\5?@ D-A!.HzG? D-A!.%@ D-A!.Gz.8@ D-A!.)\(@ D-A!.Gz.8@ D-A!.<@ D-AW1N Bullet Energy = weight in grains * velocity squared / 450,24011111112 Bullet #12  Bullet #22  Bullet #32! Bullet #42! Bullet #52! Bullet #62! Bullet #7"3 Bullet weight =~ 3F@~ 3D@~ 3 b@~ 3`z@~ 3P@~ 3p@~ 3#t@#4 Bullet velocity =~ 4@~ 4@@~ 4@~ 4@~ 4@~ 4D@~ 4"@ 6 Bullet energy =067Ct+W@D4D3{A06x`@D4D3{A06ñQA@D4D3{A0642|̒@D4D3{A06L'd@D4D3{A06_c@D4D3{A06:D@D4D3{A#7 Bullet energy rounded =!7@W@ D6A!7`@ D6A!7@ D6A!7̒@ D6A!7@ D6A!7d@ D6A!7@ D6A5;, Recoil energy of a firearm in ft-lbs;;;;;;;< Gun #1< Gun #2< Gun #3<! Gun #4<! Gun #5<! Gun #6<! Gun #7)= Weight of gun in lbs (7.5, etc.)~ =@~ =@~ =@~ =@~ =@~ =@~ =@ >Weight of bullet in grs~ >Py@~ >f@~ >b@~ >n@~ >f@~ >@~ >{@'?Weight of powder charge in grs~ ?O@~ ?Q@~ ?@C@~ ?^@~ ?@S@~ ?B@~ ?I@"@Velocity of bullet in fps~ @@~ @@@~ @\@~ @@@~ @p@~ @ܔ@~ @@A%IA%c;@3D>XD@\D?XʡEP@D=IA%LpI*5@3D>XD@\D?XʡEP@D=IA%h0@3D>XD@\D?XʡEP@D=IA%AH@3D>XD@\D?XʡEP@D=IA%l XmB@3D>XD@\D?XʡEP@D=IA%EB@3D>XD@\D?XʡEP@D=IA% /7O@3D>XD@\D?XʡEP@D="BRecoil energy smokeless =!B<@ DAA!B6@ DAA!B0@ DAA!BH@ DAA!BB@ DAA!BB@ DAA!BO@ DAAC%IC%<0@3D>XD@D?XʡEP@D=IC%*)ʥ^&@3D>XD@D?XʡEP@D=IC%2s}OF%@3D>XD@D?XʡEP@D=IC%Y|7@3D>XD@D?XʡEP@D=IC%`^5@3D>XD@D?XʡEP@D=IC%}2=@3D>XD@D?XʡEP@D=IC%poyF@3D>XD@D?XʡEP@D=%DRecoil energy black powder =!D1@ DCA!D&@ DCA!D&@ DCA!D7@ DCA!D6@ DCA!D=@ DCA!DG@ DCA>??? ) Arial