ࡱ>  grtvxzf  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqstuvwxyz{|}~Root Entry F 7Yh5Workbook _VBA_PROJECT_CUR"u6Y7YVBA }6Y๖7Y (.`\p Thad Winzenz Ba= ThisWorkbook=KxK8X@"1Arial1Arial1Arial1Arial1Arial1Arial1Arial10Arial1Arial1 Arial1QTahoma1Arial1Arial"$"#,##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;"\"\-#,##0"\"#,##0;[Red]"\"\-#,##0"\"#,##0.00;"\"\-#,##0.00#"\"#,##0.00;[Red]"\"\-#,##0.0072_ "\"* #,##0_ ;_ "\"* \-#,##0_ ;_ "\"* "-"_ ;_ @_ .)_ * #,##0_ ;_ * \-#,##0_ ;_ * "-"_ ;_ @_ ?:_ "\"* #,##0.00_ ;_ "\"* \-#,##0.00_ ;_ "\"* "-"??_ ;_ @_ 61_ * #,##0.00_ ;_ * \-#,##0.00_ ;_ * "-"??_ ;_ @_ \$#,##0_);\(\$#,##0\)\$#,##0_);[Red]\(\$#,##0\) \$#,##0.00_);\(\$#,##0.00\)% \$#,##0.00_);[Red]\(\$#,##0.00\)0.0 0.0000000 0.000000 0.00000 0.0000 0.0000_                 + ) , *   @@  @   @  @     @    `      ` @ *  ` *  ` *  $@  $  $  $ @  $  $  $  (@@  ( @  "@@  "@  " @  ` " @   (@@  @  P @  @  P  `@ +  p   #8 #x"@  h@ @ *   l@ @ +   l@ @ . #x"@ @ /  h"@ @   DD@ @ + DD@ @  ` !8   (   (@ @   (@ @  + (!@ @ "8 !8  h  `,  h0  h  (   h@  `@  p  (  h  h@@  h@  `@  ` @  h  `@  `  @  `@  `  @  `!@  ` ! @ "8@@ "8@ "8  @ "0@@ "0  @ "0@ "x  ( `1 Set-up Worksheet*2 Judges Raw ScoresSq3 Summary Scores4 Normalized Scores5 Aggregate Results 6 Unsorted ResultsJ 7 Sorted Results&`ibZ  3  @@  ?33National Yo-Yo League Freestyle Scoring SpreadsheetTPlease enter information for the following fields. These values will be used for the"Percent weight of Technical Score:$Percent weight of Performance Score:Number of Freestyle Judges:Efinal calculation of freestyle scores. The number of judges means theHThe tabs at the bottom of the page will jump you to the appropriate pageof information.FEnter the percent weight of the Technical Score. The Performance Score!will be automatically calculated.,Suggested values are already placed for you. Player NumberName (Last, First)Tech +Tech -Perf + Score, Zero Player NameTech TtlPerf TtlBYou can type in the Names of the Judges in place of the 'Judge #'.Tech NmPerf NmSum TEHigh TELow TEFinal TESum PSHigh PSLow PSFinal PS Overall ScorePlaceRESULTS Players NameDThis has the ability to accommodate up to 100 players and 11 judges.9Enter the number of judges used for the freestyles below.Division Being Judged:1A Contest Name:League Contest?number of judges for the division scores are being entered for.StateCityAddress(Normalized Scores (This sheet is locked)ZipStyle Summary Scores (Sheet is locked)/Aggregate Scores - Not sorted (Sheet is locked)Judges::  ,mS?ccz (. +"&  dMbP?_*+%MContest4C odXXLetter DINU"4qWI "dXX??U} I +J            1222222345 45 45 4)5454545 65 6 5 45 6$ 5 65 45 45 4 545 4 545454 :#< %(B 5454 :~ =? 54 :>:5 D 5454-.. ;% ?& /54-.. ;' @( 0545PQQQQQQQ U2~ V?ZZ[ W~ T@\\]DJl&&&&&&&&&&U<Q<<: !"#$%&'( )* W~ T@ \\] !W~ !T@!\\] "W~ "T@"\\] #W~ #T@#\\] $W~ $T@$\\] %W~ %T @%\\] &W~ &T"@&\\] 'W~ 'T$@'\\] (X~ (Y&@(^^_)*000000000H0(  ~  <܌ XPP? @ @]4@܌X 4 Lc4E2Co <Make sure you put in judges names or just and identifying mark below, this will automatically calculate the number of judges. If you have 6 or more judges, the high and low scores will be automatically thrown out for the final calculations< >arr  0, +@p%<]`, 4 ~<Fill in the names of the judges here, or just use an anonmymous ID, it will automatically fill in on the Raw Scores worksheet.< ~8 Thad Winzenzh>@  7 Sheet1 (.  o:JXgSn  dMbP?_*+%MHP LaserJet 4050 Series PS$S 4dXXA4PRIVB0''''` P4(pTRJPHAAHIRO BAPHAA" dXX??U} m } } 'o((( (((((( ( (  ( ( ( ((((((((((((((((((( +# , g g g g g `Z ab  `Z  ab  ` Z  ab` Z! ab`Z" ab`Z# ab`Z$ ab`Z% ab`Z&  ab!"`Z' #ab$%`"Z( &ab'   / , + * . ! " # ! " # ! " # ! " # ! " # ! " # ! " # ! " # ! " !# "! #" $# %! &" '#~ ?L 8R'~ @L 99'~ @L 99'~ @L 99'~  @L99'~  @L89'~  @L99'~  @L99'~  "@L99'~  $@L99'~  &@L89'~  (@L99'~  *@L99'~  ,@L99'~  .@L99'~  0@L89'~  1@L99'~  2@L99'~  3@L99'~  4@L99'~  5@L89'~  6@L99'Dl.."""""0^^^^^^^^^^^^^^^^^^^^^ (!("(#($(%(&('((()(*(+(,(-(.(/(0(1(2(3(4(5(6(7(8(9(:(;(<(=(>(?(~ 7@L 99'~ ! 8@L!99'~ " 9@L"99'~ # :@L#89'~ $ ;@H$'~ % <@H%'~ & =@H&'~ ' >@H''~ ( ?@H('~ ) @@H)'~ * @@H*'~ + A@H+'~ , A@H,'~ - B@H-'~ . B@H.'~ / C@H/'~ 0 C@H0'~ 1 D@H1'~ 2 D@H2'~ 3 E@H3'~ 4 E@H4'~ 5 F@H5'~ 6 F@H6'~ 7 G@H7'~ 8 G@H8'~ 9 H@H9'~ : H@H:'~ ; I@H;'~ < I@H<'~ = J@H='~ > J@H>'~ ? K@H?'D l^^^^ZZZZZZZZZZZZZZZZZZZZZZZZZZZ@(A(B(C(D(E(F(G(H(I(J(K(L(M(N(O(P(Q(R(S(T(U(V(W(X(Y(Z([(\(](^(_(~ @ K@H@'~ A L@HA'~ B L@HB'~ C M@HC'~ D M@HD'~ E N@HE'~ F N@HF'~ G O@HG'~ H O@HH'~ I P@HI'~ J @P@HJ'~ K P@HK'~ L P@HL'~ M Q@HM'~ N @Q@HN'~ O Q@HO'~ P Q@HP'~ Q R@HQ'~ R @R@HR'~ S R@HS'~ T R@HT'~ U S@HU'~ V @S@HV'~ W S@HW'~ X S@HX'~ Y T@HY'~ Z @T@HZ'~ [ T@H['~ \ T@H\'~ ] U@H]'~ ^ @U@H^'~ _ U@H_'D lZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZZ`(a(b(c(d(e(f(g(h(i(j(k(l(m(n( ~ ` U@H`'~ a V@Ha'~ b @V@Hb'~ c V@Hc'~ d V@Hd'~ e W@He'~ f @W@Hf'~ g W@Hg'~ h W@Hh'~ i X@Hi'~ j @X@Hj'~ k X@Hk'~ l X@Hl'~ m Y@Hm'~ n @Y@ nn'"ZZZZZZZZZZZZZZ (  ~  <| XPP? Z]4@| 4 Ӎ08'Lս| <Note the style of play (1A through 5A) if you are using this to score an "Open" freestyle to make it easier to keep track of the styles for each player. Otherwise, leave this blank.<    Thad Winzenz >@A   Z !"$%'   7 Sheet2 (.  h-rX8 F  dMbP?_*+%""??cU} }  h        0c ZdcgZ dcZ  d cZ d c Z dcZdcZdcZdcZdcZ"deZ%d   + * ! # ! # !  #  !  #  !  # ! # ! # ! # ! # ! # " # ?Z ;$/%Z  : B;(/%Z  : B;,/f%Z  : BC0/-Z  Z Z B;4/%Z  : BC8/-Z  Z Z B;? >@!Z'; x: %Z' :'B; |:!%Z' :'B; :%Z' :'BC :!-Z' Z'Z'B; :!%Z'  :' BC :!-Z'  Z' Z' B; :!%Z'  :' BC :!-Z'  Z' Z'B; :! %Z' :'BC : -Z' Z'Z'B; :! %Z' :'BC : -Z' Z'Z'B; :! %Z' :'BC : -Z' Z'Z'B; :!%Z' :'BC : -Z' Z'Z'B; : %Z' :'BC : -Z' Z'Z'B; : %Z' :'BC : -Z' Z'Z' B; : %Z'! :'!BC : -Z'" Z'"Z'#B; : %Z'$ :'$BC :! -Z'% Z'%Z'&B; :!%Z'' :''B! ?@"Z(;!:!%Z( :(B;!:"%Z( :(B;!: %Z( :(BC!:"-Z( Z(Z(B;!:"%Z(  :( BC!:"-Z(  Z( Z( B;!:"%Z(  :( BC!:"-Z(  Z( Z(B;! :" %Z( :(BC! ;! -Z( Z(Z(B;! ;" %Z( :(BC! ;!-Z( Z(Z(B;!  ;" %Z( :(BC!;!-Z( Z(Z(B;!;"%Z( :(BC!;!-Z( Z(Z(B;!;!%Z( :(BC! ;!-Z( Z(Z(B;!$;!%Z( :(BC!(;!-Z( Z(Z( B;!,;!%Z(! :(!BC!0;!-Z(" Z("Z(#B;!4;!%Z($ :($BC!8;" -Z(% Z(%Z(&B;!<;"%Z(' :('B" @@#Z);"@;"%Z) :)B;"D;#%Z) :)B;"H;!%Z) :)BC"L;#-Z) Z)Z)B;"P;#%Z)  :) BC"T;#-Z)  Z) Z) B;"X;#%Z)  :) BC"\;#-Z)  Z) Z)B;" `;# %Z) :)BC" d;" -Z) Z)Z)B;" h;# %Z) :)BC" l;"-Z) Z)Z)B;" p;# %Z) :)BC"t;"-Z) Z)Z)B;"x;#%Z) :)BC"|;"-Z) Z)Z)B;";"%Z) :)BC";"-Z) Z)Z)B;";"%Z) :)BC";"-Z) Z)Z) B;";"%Z)! :)!BC";"-Z)" Z)"Z)#B;";"%Z)$ :)$BC";# -Z)% Z)%Z)&B;";#%Z)' :)'B# @@$Z*;#;#%Z* :*B;#;$%Z* :*B;#;"%Z* :*BC#;$-Z* Z*Z*B;#;$%Z*  :* BC#;$-Z*  Z* Z* B;#;$%Z*  :* BC#;$-Z*  Z* Z*B;# ;$ %Z* :*BC# ;# -Z* Z*Z*B;# ;$ %Z* :*BC# ;#-Z* Z*Z*B;# ;$ %Z* :*BC#;#-Z* Z*Z*B;#;$%Z* :*BC#;#-Z* Z*Z*B;#;#%Z* :*BC#;#-Z* Z*Z*B;#;#%Z* :*BC#;#-Z* Z*Z* B;#;#%Z*! :*!BC#;#-Z*" Z*"Z*#B;#;#%Z*$ :*$BC#<$ -Z*% Z*%Z*&B;#<$%Z*' :*'B$ A@%Z+;$<$%Z+ :+B;$ <%%Z+ :+B;$<#%Z+ :+BC$<%-Z+ Z+Z+B;$<%%Z+  :+ BC$<%-Z+  Z+ Z+ B;$ <%%Z+  :+ BC$$<%-Z+  Z+ Z+B;$ (<% %Z+ :+BC$ ,<$ -Z+ Z+Z+B;$ 0<% %Z+ :+BC$ 4<$-Z+ Z+Z+B;$ 8<% %Z+ :+BC$<<$-Z+ Z+Z+B;$@<%%Z+ :+BC$D<$-Z+ Z+Z+B;$H<$%Z+ :+BC$L<$-Z+ Z+Z+B;$P<$%Z+ :+BC$T<$-Z+ Z+Z+ B;$X<$%Z+! :+!BC$\<$-Z+" Z+"Z+#B;$`<$%Z+$ :+$BC$d<% -Z+% Z+%Z+&B;$h<%%Z+' :+'B% A@&Z,;%l<%%Z, :,B;%p<&%Z, :,B;%t<$%Z, :,BC%x<&-Z, Z,Z,B;%|<&%Z,  :, BC%<&-Z,  Z, Z, B;%<&%Z,  :, BC%<&-Z,  Z, Z,B;% <& %Z, :,BC% <% -Z, Z,Z,B;% <& %Z, :,BC% <%-Z, Z,Z,B;% <& %Z, :,BC%<%-Z, Z,Z,B;%<&%Z, :,BC%<%-Z, Z,Z,B;%<%%Z, :,BC%<%-Z, Z,Z,B;%<%%Z, :,BC%<%-Z, Z,Z, B;%<%%Z,! :,!BC%<%-Z," Z,"Z,#B;%<%%Z,$ :,$BC%<& -Z,% Z,%Z,&B;%<&%Z,' :,'B& B@gZ-;&<&%Z- :-B;&<'%Z- :-B;&<%%Z- :-BC&<'-Z- Z-Z-B;&<'%Z-  :- BC&<'-Z-  Z- Z- B;&<'%Z-  :- BC&<'-Z-  Z- Z-B;& <' %Z- :-BC& <& -Z- Z-Z-B;& <' %Z- :-BC& <&-Z- Z-Z-B;& =' %Z- :-BC&=&-Z- Z-Z-B;&='%Z- :-BC& =&-Z- Z-Z-B;&=&%Z- :-BC&=&-Z- Z-Z-B;&=&%Z- :-BC&=&-Z- Z-Z- B;& =&%Z-! :-!BC&$=&-Z-" Z-"Z-#B;&(=&%Z-$ :-$BC&,=' -Z-% Z-%Z-&B;&0='%Z-' :-'B' B@(Z.;'4='%Z. :.B;'8=(%Z. :.B;'<=&%Z. :.BC'@=(-Z. Z.Z.B;'D=(%Z.  :. BC'H=(-Z.  Z. Z. B;'L=(%Z.  :. BC'P=(-Z.  Z. Z.B;' T=( %Z. :.BC' X=' -Z. Z.Z.B;' \=( %Z. :.BC' `='-Z. Z.Z.B;' d=( %Z. :.BC'h='-Z. Z.Z.B;'l=(%Z. :.BC'p='-Z. Z.Z.B;'t='%Z. :.BC'x='-Z. Z.Z.B;'|='%Z. :.BC'='-Z. Z.Z. B;'='%Z.! :.!BC'='-Z." Z."Z.#B;'='%Z.$ :.$BC'=( -Z.% Z.%Z.&B;'=(%Z.' :.'B( C@)Z/;(=(%Z/ :/B;(=)%Z/ :/B;(='%Z/ :/BC(=)-Z/ Z/Z/B;(=)%Z/  :/ BC(=)-Z/  Z/ Z/ B;(=)%Z/  :/ BC(=)-Z/  Z/ Z/B;( =) %Z/ :/BC( =( -Z/ Z/Z/B;( =) %Z/ :/BC( =(-Z/ Z/Z/B;( =) %Z/ :/BC(=(-Z/ Z/Z/B;(=)%Z/ :/BC(=(-Z/ Z/Z/B;(=(%Z/ :/BC(=(-Z/ Z/Z/B;(=(%Z/ :/BC(=(-Z/ Z/Z/ B;(=(%Z/! :/!BC(=(-Z/" Z/"Z/#B;(=(%Z/$ :/$BC(=) -Z/% Z/%Z/&B;(=)%Z/' :/'B) C@*Z0;)=)%Z0 :0B;)>*%Z0 :0B;)>(%Z0 :0BC)>*-Z0 Z0Z0B;) >*%Z0  :0 BC)>*-Z0  Z0 Z0 B;)>*%Z0  :0 BC)>*-Z0  Z0 Z0B;) >* %Z0 :0BC)  >) -Z0 Z0Z0B;) $>* %Z0 :0BC) (>)-Z0 Z0Z0B;) ,>* %Z0 :0BC)0>)-Z0 Z0Z0B;)4>*%Z0 :0BC)8>)-Z0 Z0Z0B;)<>)%Z0 :0BC)@>)-Z0 Z0Z0B;)D>)%Z0 :0BC)H>)-Z0 Z0Z0 B;)L>)%Z0! :0!BC)P>)-Z0" Z0"Z0#B;)T>)%Z0$ :0$BC)X>* -Z0% Z0%Z0&B;)\>*%Z0' :0'B* D@+Z1;*`>*%Z1 :1B;*d>+%Z1 :1B;*h>)%Z1 :1BC*l>+-Z1 Z1Z1B;*p>+%Z1  :1 BC*t>+-Z1  Z1 Z1 B;*x>+%Z1  :1 BC*|>+-Z1  Z1 Z1B;* >+ %Z1 :1BC* >* -Z1 Z1Z1B;* >+ %Z1 :1BC* >*-Z1 Z1Z1B;* >+ %Z1 :1BC*>*-Z1 Z1Z1B;*>+%Z1 :1BC*>*-Z1 Z1Z1B;*>*%Z1 :1BC*>*-Z1 Z1Z1B;*>*%Z1 :1BC*>*-Z1 Z1Z1 B;*>*%Z1! :1!BC*>*-Z1" Z1"Z1#B;*>*%Z1$ :1$BC*>+ -Z1% Z1%Z1&B;*>+%Z1' :1'B+ D@,Z2;+>+%Z2 :2B;+>,%Z2 :2B;+>*%Z2 :2BC+>,-Z2 Z2Z2B;+>,%Z2  :2 BC+>,-Z2  Z2 Z2 B;+>,%Z2  :2 BC+>,-Z2  Z2 Z2B;+ >, %Z2 :2BC+ >+ -Z2 Z2Z2B;+ >, %Z2 :2BC+ >+-Z2 Z2Z2B;+ >, %Z2 :2BC+>+-Z2 Z2Z2B;+>,%Z2 :2BC+?+-Z2 Z2Z2B;+?+%Z2 :2BC+?+-Z2 Z2Z2B;+ ?+%Z2 :2BC+?+-Z2 Z2Z2 B;+?+%Z2! :2!BC+?+-Z2" Z2"Z2#B;+?+%Z2$ :2$BC+ ?, -Z2% Z2%Z2&B;+$?,%Z2' :2'B, E@-Z3;,(?,%Z3 :3B;,,?-%Z3 :3B;,0?+%Z3 :3BC,4?--Z3 Z3Z3B;,8?-%Z3  :3 BC,;7tC7%Z> :>B;7xC8%Z> :>B;7|C6%Z> :>BC7C8-Z> Z>Z>B;7C8%Z>  :> BC7C8-Z>  Z> Z> B;7C8%Z>  :> BC7C8-Z>  Z> Z>B;7 C8 %Z> :>BC7 C7 -Z> Z>Z>B;7 C8 %Z> :>BC7 C7-Z> Z>Z>B;7 C8 %Z> :>BC7C7-Z> Z>Z>B;7C8%Z> :>BC7C7-Z> Z>Z>B;7C7%Z> :>BC7C7-Z> Z>Z>B;7C7%Z> :>BC7C7-Z> Z>Z> B;7C7%Z>! :>!BC7C7-Z>" Z>"Z>#B;7C7%Z>$ :>$BC7C8 -Z>% Z>%Z>&B;7C8%Z>' :>'B8 K@ Z?;8C8%Z? :?B;8C9%Z? :?B;8C7%Z? :?BC8C9-Z? Z?Z?B;8C9%Z?  :? BC8C9-Z?  Z? Z? B;8C9%Z?  :? BC8C9-Z?  Z? Z?B;8 C9 %Z? :?BC8 C8 -Z? Z?Z?B;8 D9 %Z? :?BC8 D8-Z? Z?Z?B;8 D9 %Z? :?BC8 D8-Z? Z?Z?B;8D9%Z? :?BC8D8-Z? Z?Z?B;8D8%Z? :?BC8D8-Z? Z?Z?B;8 D8%Z? :?BC8$D8-Z? Z?Z? B;8(D8%Z?! :?!BC8,D8-Z?" Z?"Z?#B;8      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrsuvwxyz{|}~0D8%Z?$ :?$BC84D9 -Z?% Z?%Z?&B;88D9%Z?' :?'B9 K@:Z@;9