ࡱ> A@  !"#$%&'()*+,-./0123456789:;<=>?GCDEFXlIJKLMNPQRSTUVWHmZ[\]^h`abcdefgYijkopqrs}uvwxyz{|n~Root Entry Fg' {;^B;Workbook%<{_VBA_PROJECT_CUR"#" ,-z;^ {;^VBA ,-z;^ ^z;^ L\p Guy Bartle Ba= ThisWorkbook=,`8X@"1" Helvetica1Geneva1Geneva1Geneva1" Helvetica1" Helvetica1"h Helvetica1" Helvetica1"  Helvetica1"$ Helvetica1" Helvetica""#,##0;\-""#,##0""#,##0;[Red]\-""#,##0""#,##0.00;\-""#,##0.00#""#,##0.00;[Red]\-""#,##0.005*0_-""* #,##0_-;\-""* #,##0_-;_-""* "-"_-;_-@_-,)'_-* #,##0_-;\-* #,##0_-;_-* "-"_-;_-@_-=,8_-""* #,##0.00_-;\-""* #,##0.00_-;_-""* "-"??_-;_-@_-4+/_-* #,##0.00_-;\-* #,##0.00_-;_-* "-"??_-;_-@_-"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)72_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).)_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)61_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)0.0"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\) @  |@  |@  |@  |@  |@  |@  |@  |@  |@  |@  |@  |@  |@  |@  @  @ ( @    @  @ #@  @ #@  @  @  @  @ #@ #@ #@  @ #@ #8@@  @ #8@@ #@ #0@@ #0 @@ #0 @ #0 @  1 @   (@@@   (@ @  8wwwUUU333DU3ffff̙̙3f3fff3f3f33333f33333\` ]A_6,a_r1: a_r2: ap_r1: ap_r2:  Averages.Averagesb_r1: b_r2: bp_r1: bp_r2: c_r1:c_r2:cp_r1:d_r1:d_r2: dp_r1:e_r1:e_r2:ep_r1: f_r1:f_r2: fp_r1: g_r1:*gp_r1:+ Prepare.Prepare  ;% Round1.Round1 Round2.Round2 Round3.Round3 Round4.Round4 Round5.Round5"ZR3  @@  x<AveragesR1R2R3R4R5Avg.HandicapPts Total PtsAgg: League TableAggBSSRA Div. A(iii) Spring 2006 Dauntsey's AElizabeth College A Felsted A Sedbergh B St Bede's A The Oratory AVictoria College BAvcock M Betteley J Knights JNapper A Windsor JBerger OBrett G Coupland CDavies A Vincent JBriggs AKnight PMaher AWaters R Willcocks J Baudains ACoates ADu Feu JSutton HWhite CGreen MHowson LOgden G Pimblett ASteven W Atterton B Beardsworth G Kengesa PWhite B"Guy Bartle Creative Media Serviceswww.guybartle.comAvery T Grummitt FGraham NRuss CTovey MDNSHunter K.Comments: Congratulations to Victoria Collage.B <B%z4:cc L /^Dr  dMbP?_*+%&L&C&L&C&~?'~?(~?)~?MTEPSON Stylus Photo 950pv 4dhh4 P*** qhhDLLName32=E_DU14KE.DLL L dL 2EPSON Stylus Photo 950 ***" d,, `? `?U} } } } }  } } } } } $  Avg.(Column O)`/@@       cD BSSRA Div. A(iii) Spring 2006   %      %                ! #4$V@V@W@@W@U@ #$V@W@W@W@W@  cD Atterton B7 X@ !D  $B7 X@ !D  $B7 X@!D  $B7 X@ !D  $B7 @X@ !D  $B#!ffffffX@  %B #5$V@W@V@W@U@ # $@W@W@X@@X@U@   cD% Coates A7 W@!D%  $%B7 @X@!D%  $%B7 @W@!D%  $%B7 X@!D%  $%B7 W@!D%  $%B#!W@ %B #6$X@W@@W@X@W@ #!$@U@W@U@W@W@  cD Graham N7X@!D  $B7W@!D  $B7@W@!D  $B7X@!D  $B7W@!D  $B#!W@ %B #7$V@V@X@@W@U@ #"$X@V@W@X@U@  <cD Ogden G7 @W@!D  $B7 X@!D   $ B7 W@!D   $ B7 X@!D   $ B7 X@!D   $ B#!W@ %B #8$T@U@U@V@U@ ##$@U@U@@T@@V@U@   cD( White C7 W@!D(  $(B7 @W@!D(  $(B7 W@!D(  $(B7 W@!D(  $(B7 @W@!D(  $(B#!W@ %B 7!D  $B7!D  $B7!D  $B7!D  $B 7 !D   $B7  !D   $ B7  !D   $ B7  !D   $ B @cD Briggs A7V@"!D  $B7W@ !D   $ B7W@ !D   $ B7W@ !D   $ B7W@ !D   $ B#!33333sW@  %B # "`|@  %B# "P|@  %B# "|@  %B# "}@  %B# "{@  %B  # $ |@ %B# "|@ % B# "0|@ % B# "@}@ % B# "0|@  % B  <c D Davies A7  V@!D  $B7  W@!D   $ B7  X@!D   $ B7  Pc!D   $ B7  Tc!D   $ B# !jW@ % B $ @@@@@  $ @@@@@   Tc D Knight P7 @W@!D  $B7 W@!D   $ B7 X@!D   $ B7 @X@!D   $ B7 U@!D   $ B# !ffffffW@ % B  # 6@  % B   # ¡@  % B   # 9@ %  B   # ʡ@ %  B  c D White B7  W@!D  $B7  V@!D  $B7  W@!D  $B7  W@!D  $B7  W@!D  $B# !ffffffW@$ % B"    c D Beardsworth G7  W@!D  $B7  V@!D  $B7  W@!D  $B7  W@!D  $B7  @W@!D  $B# !@W@ % B  %       %      c D Betteley J7  X@%!D  $B7  V@%!D  $B7  V@%!D  $B7  W@%!D  $B7  W@%!D  $B# !@W@ % B #.$X@X@X@X@@X@ #)$V@T@S@U@O@   cD' Sutton H7 @X@!D'  $'B7 V@!D'  $'B7 W@!D'  $'B7 @W@!D'  $'B7 V@!D'  $'B#!@W@ %B #/$W@V@W@W@@W@ #*U@U@U@V@  9 cD Kengesa P7 W@!D  $B7 V@!D  $B7 W@!D  $B7 V@!D  $B7 X@!D  $B#!W@  %B #:$W@U@V@@V@@V@ #+$@W@X@W@X@X@  xcD Waters R7X@!D  $B7V@!D   $ B7W@!D   $ B7X@!D   $ B7U@!D   $ B#! W@  %B #0$W@V@W@V@X@ #,$@V@V@U@@U@V@   tc)D$ Baudains A7 V@!D$  $$B7 @W@!D$  $$B7 U@!D$  $$B7 W@!D$  $$B7 W@!D$  $$B#!W@ %B #1$W@V@W@W@W@ #-$V@V@@U@S@@T@   cD& Du Feu J7 @V@!D&  $&B7 W@!D&  $&B7 @W@!D&  $&B7 W@!D&  $&B7 V@!D&  $&B#!33333V@ %B 7 !D  $B7!D  $B7!D  $B7!D  $B 7 !D   $B7  !D   $ B7  !D   $ B7  !D   $ B cD Avery T7V@!D  $B7V@"!D  $B7W@"!D  $B7@W@"!D  $B7U@"!D  $B#!V@ %B #"p}@ %B#"@|@ %B#"P}@ %B#"0}@ %B#"`}@ %B  #${@ %B# "{@ % B# "z@ % B# "P{@ % B# "pt@ % B cD Grummitt F7V@!D  $B7W@!D  $B7V@!D  $B7W@!D  $B7U@!D  $B#!V@ %B $@@@@@ $@@?@@  cD Russ C7V@!D  $B7V@!D  $B7X@!D  $B7@W@!D  $B7U@!D  $B#!V@" %B  #>@ %B   #2@ %B  #$@ % B     # D@! % B cD Brett G7 W@#!D  $B7 V@#!D   $ B7 W@#!D   $ B7  c#!D   $ B7 c#!D   $ B#!UUUUUV@ %B"   cD Napper A7 V@!D  $B7 W@!D  $B7 W@!D  $B7 W@!D  $B7 @V@!D  $B#!V@ %B  %      %         cD Knights J7 W@ !D  $B7 V@ !D  $B7 V@ !D  $B7 V@ !D  $B7 W@ !D  $B#!V@ %B #$R@Q@T@@T@@S@ #S@@V@T@   cD Coupland C7 @W@*!D  $B7 W@!D   $ B7 @U@!D   $ B7 4c!D   $ B7 8c!D   $ B#!V@ %B #$X@V@V@W@W@ #W@V@W@   hcD Maher A7@U@ !D  $B7W@ !D   $ B7U@ !D   $ B7W@ !D   $ B7W@ !D   $ B#!V@  %B #$W@V@V@V@W@ #@W@W@@U@   cD Windsor J7 V@!D  $B7 W@!D  $B7 T@!D  $B7 W@!D  $B7 @V@!D  $B#!ffffffV@# %B #$V@W@W@W@@V@ #V@W@X@   cD Hunter K7 W@ !D  $B7 U@ !D  $B7 V@ !D  $B7 @V@ !D  $B7 @V@ !D  $B#!LV@ %B #$V@W@T@W@@V@ #U@@U@V@   LcD Pimblett A7 @V@!D  $B7 V@!D   $ B7 U@!D   $ B7 @U@!D   $ B7 V@!D   $ B#!33333U@ %B 7 !D  $B7!D  $B7!D  $B7!D  $B 7 !D   $B7  !D   $ B7 c !D   $ B7 c !D   $ B XcD Vincent J7 U@ !D  $B7 @U@ !D   $ B7 V@ !D   $ B7 lc !D   $ B7 pc !D   $ B#!UUUUUU@! %B #"{@ %B#"{@ %B#"@{@ %B#"@|@ %B#"{@ %B  #"P{@ %B# "0|@ % B# "{@ % B# " % B# "  % B  cD Howson L7 U@$!D  $B7 U@$!D   $ B7 U@$!D   $ B7 V@$!D   $ B7 4c$!D   $ BDNS#!U@ %BDFlQ$:&9 !"#$%&'()*+,. $ @?@@@  $ ?@@??   c D Willcocks J7 @U@!D  $B7 U@!D   $ B7 @T@!D   $ B7 @V@!D   $ B7 U@!D   $ B# !33333sU@ % B ! #!&@! % B ! ! #!>@! %B! ! #!"@! %  B !  !  #! ̔@' % B! !dc!D Steven W7! V@!D  $B7! V@!D   $ B7! @U@!D   $ B7! S@!D   $ B7! @T@!D   $ B#!!LU@% %!!B""   "(c"D Tovey M7"T@!D  $B7"U@!D  $B7"U@!D  $B7"V@!D  $B7"U@!D  $B#"!LU@ %""B # #% # # # ## # ##  #  #  #c#D Berger O7# S@!D  $B7# @V@!D   $ B7# T@!D   $ B7# c!D   $ B7# c!D   $ B##!UUUUUT@ %##B $#$$$V@@W@U@W@W@$ $cD#Victoria College B~ $@@$ 4@,D, $  $c$D Green M7$ V@ !D  $B7$ T@!!D   $ B7$ S@!!D   $ B7$ U@!!D   $ B7$ O@!!D   $ B#$!fffffS@ %$$B %#%$%W@@X@@W@X@W@% % c% D  Felsted A~ %>@% % 2@)D %  %xc%D Avcock M7% R@!!D  $B7% Q@!D  $B7% T@!D  $B7% @T@!D  $B7% @S@!D  $B#%!fffff&S@  %%%B &#&$&@V@W@@W@W@V@& & c& DElizabeth College A~ &9@& & ʡ@%D &  ! '#'$'@X@V@W@@W@V@' ' <c' D Dauntsey's A~ '6@' ' ¡@&D '  ! (#($(W@@W@W@W@@W@( ( Xc( D St Bede's A~ (&@( ( >@*D!(  ! ))7) !D$  $)B7))!D$  $)B7))!D$  $)B7))!D$  $)B) ) pc) D  Sedbergh B~ )$@) ) D@(D )  !* #*" }@* %$)B#*"@}@* %$)B#*"|@* %$)B#*"}@, %$)B#*"|@* %$)B* c* D The Oratory A~ *"@* * ̔@,gD! +$+@@@@@ ++;+&&&&' , #,@@$ %++B , , #,4@$ %**B,,(((() .2 .*3 027X(  x  6LCC@],@LDog9 $<R1<xx  6CC@],@(`og9 $<R2<tixx  6CC@],@X|og$9 $<R3<xx  6 CC@],@ og9 $<R4<xx  6̹CC@],@̹og\9 $<R5<xx  6hCC@A],@hog9 $< Averages<9xx  6CC@],@og9 $<Prepare<0Xrk>&@m7..yK www.guybartle.comyK 4http://www.guybartle.com/ Sheet1. SrCC:\Documents and Settings\guy\My Documents\Shooting\BSSRA\bssra.htm A_7_21436BSSRA Div. A(iii) Spring 2006%M#LC:\Documents and Settings\guy\My Documents\Shooting\BSSRA\bssra_averages.htm4A_7_9037D&BSSRA Div. A(iii) Spring 2006 Averages ThisWorkbookSheet1 ~__SRP_10"__SRP_11&B  !#$%')*,./13468:<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefhijklmnopqrtvwy{|}~'%%#xME (SLSS<N0{00020819-0000-0000-C000-000000000046}@(%H@0G7xAttribute VB_Name = "ThisWorkbook" Bas0{00020P819-0C$0046} |GlobalSpacFalse dCreatablPredeclaIdTru BExposeTemplateDerivBustomizD2<jx%%#<0rSHh?8 F E3 #x E3 #0rSHh?8ME(SLSS6"N0{00020820-0000-0000-C000-000000000046}(%H` % %`h8@HH0G7$*\Rffff*0M4590f3ef4xAttribute VB_Name = "She@et1" Bast0{00020820- C$0046} |Global!SpacFalse dCreatablPre declaIdTru BExposeTemplateDeriv$Bustom izD2rU H)Q4y`rU @nRound1O`__SRP_6(__SRP_7+gRound2__%d_r1$f_r1$  'k d_r1$g_r1$  'k dp_r1+'e_r1$b_r1$  'ke_r1$c_r1$  'kXe_r1$d_r1$  'k e_r1$a_r1$  'ke_r1$f_r1$  'ke_r1$g_r1$  'kx ep_r1+'f_r1$b_r1$  'k f_r1$c_r1$  'kf_r1$d_r1$  'kf_r1$e_r1$  'kxf_r1$a_r1$  'k@f_r1$g_r1$  'k fp_r1+'g_r1$b_r1$  'kg_r1$c_r1$  'kxg_r1$d_r1$  'k@g_r1$e_r1$  'kg_r1$a_r1$  'kg_r1$f_r1$  'k gp_r1+H37:K43$B@H"I37$$ (&K37$* (, 0.24 86 B@"A1:M45$B@HM45$B@: $A$1:$M$45 <!>(@ B(DA2$B@H <!>9F9Hq` $A$1:$M$45 <!>(@ <!>&c9J&r9L9N&c9P&r9R9T~? X%Z9V~? X%Z9\~? X%Z9^~? X%Z9` `? X%Z9b `? X%Z9d9f9h l9j9n9p r969t x9v |9z 9~9999q B!B@oAttribute VB_Name = "Round1" Sub 0() '8 Macro< recorded 02/09/99 by Guy Bart$leP  Dim points As Int@eger = 1 If Range("a_r1") >bThen' 6S+?End If[ Ic+I$dE$eE$fE$g+lp =Dg g wsw{0wM6w 6w 6w 6w 3wb;gpKwd0_w^w- D!Gw ; ”;  ;  ; Dwc;$D';;- 4C; Dt) ; ; W;*e6;3Y_w|_wzb  4_"?&_" D";0ct r 5_"_"[" _"   "fr %    "T#&  gH37:K43").Sel(ect ion.Sort K ey1:=I3@7"), OrPxlDesce@nding,2) _ "KX[Header:=xlGuessCusto m:=1,tc hCase9:= Falseie0ntat 1TopToBot A1:M45Activat1 eSheet.PageSetup.PrAreaQ$A$1:$M$`3Window.SllRowr @2lWith> sTi{0sColumn e!I   Left &c  .CenterHeader = "&r"  .Rightp hLeftFooxlc 6:8 TMarginTApplication.InchesToPoints(0.748031496062992) >ETop!984251968503937DBottom>###511811023628204F>#PrC`$ingsiF0alse_Gr@idlineCommxl Noorizontally1@Tru Vert@ROriBortraitDraftN3aperSiLzeAA4 FirstPageNumbxlAu@}@c OrxlDownTh@enOverBlackAndWhit "Zoobm'Fit@shWid 1TN@End WithCActiveWindow.SelectedSheets."3Out Copies:=1,@llate:=0A Sub #%%xME(6 << < ` `%h`XG7$*\Rffff*0H4590f34f"   ,( X `hp x   @P Xx   @P Xx    08P Xx    0 8Xh p   0 8Xh p  0 8Xh p   8H Pp   8H Pp     8 H  P p          (  0 P ` h  h   0  P `  x              8 P h                  ( H X  Round1 Macro& Macro recorded 02/09/99 by Guy Bartle]@'a_r1$b_r1$  'ckPa_r1$c_r1$  '}ka_r1$d_r1$  'ka_r1$e_r1$  'ka_r1$f_r1$  'kpa_r1$g_r1$  'k8 ap_r1+'b_r1$a_r1$  'kb_r1$c_r1$  'kb_r1$d_r1$  'kpb_r1$e_r1$  'k8b_r1$f_r1$  'kb_r1$g_r1$  'k bp_r1+'c_r1$b_r1$  'kpc_r1$a_r1$  'k8c_r1$d_r1$  'kc_r1$e_r1$  'kc_r1$f_r1$  'kc_r1$g_r1$  'kX cp_r1+'d_r1$b_r1$  'kd_r1$c_r1$  'kd_r1$a_r1$  'kd_r1$e_r1$  'kXrU~| 0  krU $`nrU~| 0  kxc_r1$%d_r1$%  'kc_r1$%e_r1$%  'kc_r1$%f_r1$%  'kPc_r1$%g_r1$%  'k cp_r1$,'d_r1$%b_r1$%  'kpd_r1$%c_r1$%  'kd_r1$%a_r1$%  'kd_r1$%e_r1$%  'khd_r1$%f_r1$%  'kd_r1$%g_r1$%  'k dp_r1$,'e_r1$%b_r1$%  'k0e_r1$%c_r1$%  'ke_r1$%d_r1$%  'ke_r1$%a_r1$%  'k(e_r1$%f_r1$%  'ke_r1$%g_r1$%  'kx ep_r1$,'f_r1$%b_r1$%  'kf_r1$%c_r1$%  'kf_r1$%d_r1$%  'k@f_r1$%e_r1$%  'kf_r1$%a_r1$%  'kf_r1$%g_r1$%  'k8 fp_r1$,'g_r1$%b_r1$%  'kg_r1$%c_r1$%  'kXg_r1$%d_r1$%  'kg_r1$%e_r1$%  'kg_r1$%a_r1$%  'kPg_r1$%f_r1$%  'k gp_r1$,H37:K43$B@H"I37$$ (&K37$* (, 0.24 86 B@"A1:M45$B@HM45$B@: $A$1:$M$45 <!>(@ B(DA2$B@H <!>9F9Hq $A$1:$M$45 <!>(@ <!>&c9J&r9L9N&c9PV%xME(6 << < ` `%h`XG7$*\Rffff*0I4590f34f"   ,( X `hp<x< <(hx<<(<0p"<<P`<h<<Xh<p"<8H<P<<@P<X<"0<8x<<(8<@<<0 @ "H p <x   <   <( h x <   <  ( <0 p  "  <   < P ` <h   <   < X h <p   "  < 8H<P<<@P<X<"0hH  (8@HP p    0H`hpx  Round2 Macro& Macro recorded 02/09/99 by Guy Bartle]@'a_r1$%b_r1$% a_r1  '$k0a_r1$%c_r1$%   'ka_r1$%d_r1$%   'ka_r1$%e_r1$%   'k(a_r1$%f_r1$%  'ka_r1$%g_r1$%  'kx ap_r1$,'b_r1$%a_r1$%  'kb_r1$%c_r1$%  'kb_r1$%d_r1$%  'k@b_r1$%e_r1$%  'kb_r1$%f_r1$%  'kb_r1$%g_r1$%  'k8 bp_r1$,'c_r1$%b_r1$%  'kc_r1$%a_r1$%  'kX&r9R9T~? X%Z9V~? X%Z9\~? X%Z9^~? X%Z9` `? X%Z9b `? X%Z9d9f9h l9j9n9p r969t x9v |9z 9~9999q(  B!B@o Attribute VB_Name = "Round2" Sub 0() '8 Macro< recorded 02/09/99 by Guy Bart$leP  Dim points As Int@eger = 1 If Range("a_r1").Offset(0, 1) >bTheZnA Pm+YE`nd If $cc1$1d_1e_1f{gœp= ĊMFpӚPs`i]Z P_ ("Z P_ \ PW PbPg狡@ 8z _]+("Z P_ \ P_ \ P_ \ PW PcPqzP/?y {?PoDpc8pThenIf"bd_be_1a_16f81zpo D H37:K43Select{ ion.Sort Key1:=D I37"),@ Order@xlDescendPing,A 2E _ "KH @K Hea:=x@lGuessCustom:=1, MatchCase:=FalseA ient at+TopTpoBot .A1:M45L:Activate BeSheet.PageSet up.PrArea"$A$10:$M$ Window.ScrollRow A A"2!With.  Title""RColumn aA  .0Leftc9#&cC@4errpRighHI Footer   Margin ApplicG.InchesToPb(0.748031496062992)(.=sUa984251968503937)]351181102362204C."mA Y}/Gri dlineCoLmm@OxlBNoe Soriz"o`llyCTrudocVertE2Or& raiDra ftaper0SizeA4AFirstNumbbaxlAu;`VcxrY2Down{OverBlackAnd0WhitZoommFitP1`PsWidqMB TallGLveQfedUsMOut CopXiesR_pLlX:=sSub __SRP_8-__SRP_9 0gRound3tE%__SRP_a2rU $`nrU~|  0  kxrU $ `nrU $ d_r1$%  'kc_r1$%e_r1$%  'kc_r1$%f_r1$%  'kPc_r1$%g_r1$%  'k cp_r1$,'d_r1$%b_r1$%  'kpd_r1$%c_r1$%  'kd_r1$%a_r1$%  'kd_r1$%e_r1$%  'khd_r1$%f_r1$%  'kd_r1$%g_r1$%  'k dp_r1$,'e_r1$%b_r1$%  'k0e_r1$%c_r1$%  'ke_r1$%d_r1$%  'ke_r1$%a_r1$%  'k(e_r1$%f_r1$%  'ke_r1$%g_r1$%  'kx ep_r1$,'f_r1$%b_r1$%  'kf_r1$%c_r1$%  'kf_r1$%d_r1$%  'k@f_r1$%e_r1$%  'kf_r1$%a_r1$%  'kf_r1$%g_r1$%  'k8 fp_r1$,'g_r1$%b_r1$%  'kg_r1$%c_r1$%  'kXg_r1$%d_r1$%  'kg_r1$%e_r1$%  'kg_r1$%a_r1$%  'kPg_r1$%f_r1$%  'k gp_r1$,H37:K43$B@H"I37$$ (&K37$* (, 0.24 86 B@"A1:M45$B@HM45$B@: $A$1:$M$45 <!>(@ B(DA2$B@H <!>9F9Hq $A$1:$M$45 <!>(@ <!>&c9J&r9L9N&c9P&r9R>%k7xME(6 << < ` `%h`XG7$*\Rffff*0J4590f34f"   ,( X `hp<x< <(hx<<(<0p"<<P`<h<<Xh<p"<8H<P<<@P<X<"0<8x<<(8<@<<0 @ "H p <x   <   <( h x <   <  ( <0 p  "  <   < P ` <h   <   < X h <p   "  < 8H<P<<@P<X<"0hH  (8@HP p    0H`hpx Round3 Macro& Macro recorded 02/09/99 by Guy Bartle]@'a_r1$%b_r1$% a_r1  '$k0a_r1$%c_r1$%   'ka_r1$%d_r1$%   'ka_r1$%e_r1$%   'k(a_r1$%f_r1$%   'ka_r1$%g_r1$%   'kx ap_r1$,''b_r1$%a_r1$%   'kb_r1$%c_r1$%   'kb_r1$%d_r1$%   'k@b_r1$%e_r1$%   'kb_r1$%f_r1$%  'kb_r1$%g_r1$%  'k8 bp_r1$,'c_r1$%b_r1$%  'kc_r1$%a_r1$%  'kXc_r1$%9T~? X%Z9V~? X%Z9\~? X%Z9^~? X%Z9` `? X%Z9b `? X%Z9d9f9h l9j9n9p r969t x9v |9z 9~9999q(  B!B@o Attribute VB_Name = "Round3" Sub 0() '8 Macro< recorded 02/09/99 by Guy Bart$leP  Dim points As Int@eger = 1 If Range("a_r1").Offset(0, 2) >bTheZnA Pm+YE`nd If $cc1$1d_1e_1f{gœp= ĊMFpӚPs`i]Z P_ ("Z P_ \ PW PbPg狡@ 8z _]+("Z P_ \ P_ \ P_ \ PW PcPqzP/?y {?PoDpc8pThenIf"bd_be_1a_16f81zpo D H37:K43Select{ ion.Sort Key1:=D I37"),@ Order@xlDescendPing,A 2E _ "KH @K Hea:=x@lGuessCustom:=1, MatchCase:=FalseA ient at+TopTpoBot .A1:M45L:Activate BeSheet.PageSet up.PrArea"$A$10:$M$ Window.ScrollRow A A"2!With.  Title""RColumn aA  .0Leftc9#&cC@4errpRighHI Footer   Margin ApplicG.InchesToPb(0.748031496062992)(.=sUa984251968503937)]351181102362204C."mA Y}/Gri dlineCoLmm@OxlBNoe Soriz"o`llyCTrudocVertE2Or& raiDra ftaper0SizeA4AFirstNumbbaxlAu;`VcxrY2Down{OverBlackAnd0WhitZoommFitP1`PsWidqMB TallGLveQfedUsMOut CopXiesR_pLlX:=wSub __SRP_b 5gRound4*__SRP_c'__SRP_d7g9 by Guy Bartle]@'a_r1$%b_r1$% a_r1  '$k0a_r1$%c_r1$%   'ka_r1$%d_r1$%   'ka_r1$%e_r1$%   'k(a_r1$%f_r1$%  'ka_r1$%g_r1$%  'kx ap_r1$,'b_r1$%a_r1$%  'kb_r1$%c_r1$%  'kb_r1$%d_r1$%  'k@b_r1$%e_r1$%  'kb_r1$%f_r1$%  'kb_r1$%g_r1$%  'k8 bp_r1$,'c_r1$%b_r1$%  'kc_r1$%a_r1$%  'kXc_r1$%d_r1$%  'kc_r1$%e_r1$%  'kc_r1$%f_r1$%  'kPc_r1$%g_r1$%  'k cp_r1$,'d_r1$%b_r1$%  'kpd_r1$%c_r1$%  'kd_r1$%a_r1$%  'kd_r1$%e_r1$%  'khd_r1$%f_r1$%  'kd_r1$%g_r1$%  'k dp_r1$,'e_r1$%b_r1$%  'k0e_r1$%c_r1$%  'ke_r1$%d_r1$%  'ke_r1$%a_r1$%  'k(e_r1$%f_r1$%  'ke_r1$%g_r1$%  'kx ep_r1$,'f_r1$%b_r1$%  'kf_r1$%c_r1$%\($%xME86 LLL<<< `k`z%@xHp(08 <BX@`h @X @8T @D @4 @$ ȩ@ @ @  Ta@P @ @h ma@ @ @@ @ @ Re@ @x @(h ew@X @XH @p8 '@( ?@  @ @ ( @  '@H`8@ ` @`H@ 0lrx|0X`XG7$*\Rffff*0K4590f34f*\R1*#2ac*\R1*#e8*\R1*#1c8*\R1*#94*\R1*#a2*\R1*#10*\R1*#1c4*\R1*#d7*\R1*#83*\R1*#56*\R1*#79*\R1*#50*\R1*#dc"   ,( X `hp<x <  <( hx< < (<0 p"V< < P`<h < < Xh<p "V< 8H<P < < @P<X < "V0<8 x< < (8<@ < < 0 @ "VH p <x   <    <(  h x <   <   ( <0  p  "V  <   <  P ` <h   <   <  X h <p   "V  <  8H<P < < @P<X < "V(0hH((( $( %(8@ H(P %p    ;;;;;0;H`hp x  Z Round4 Macro& Macro recorded 02/09/9  'kf_r1$%d_r1$%  'k@f_r1$%e_r1$%  'kf_r1$%a_r1$%  'kf_r1$%g_r1$%  'k8 fp_r1$,'g_r1$%b_r1$%  'kg_r1$%c_r1$%  'kXg_r1$%d_r1$%  'kg_r1$%e_r1$%  'kg_r1$%a_r1$%  'kPg_r1$%f_r1$%  'k gp_r1$,H37:K43$B@H"I37$$ (&K37$* (, 0.24 86 B@"A1:M45$B@HM45$B@: $A$1:$M$45 <!>(@ B(DA2$B@H <!>9F9Hq $A$1:$M$45 <!>(@ <!>&c9J&r9L9N&c9P&r9R9T~? X%Z9V~? X%Z9\~? X%Z9^~? X%Z9` `? X%Z9b `? X%Z9d9f9h l9j9n9p r969t x9v |9z 9~9999q(  B!B@o Attribute VB_Name = "Round4" Sub 0() '8 Macro< recorded 02/09/99 by Guy Bart$leP  Dim points As Int@eger = 1 If Range("a_r1").Offset(0, 3) >bTheZnA Pm+YE`nd If $cc1$1d_1e_1f{gœp= ĊMFpӚPs`i]Z P_ ("Z P_ \ PW PbPg狡@ 8z _]+("Z P_ \ P_ \ P_ \ PW PcPqzP/?y {?PoDpc8pThenIf"bd_be_1a_16f81zpo D H37:K43Select{ ion.Sort Key1:=D I37"),@ Order@xlDescendPing,A 2E _ "KH @K Hea:=x@lGuessCustom:=1, MatchCase:=FalseA ient at+TopTpoBot .A1:M45L:Activate BeSheet.PageSet up.PrArea"$A$10:$M$ Window.ScrollRow A A"2!With.  Title""RColumn aA  .0Leftc9#&cC@4errpRighHI Footer   Margin ApplicG.InchesToPb(0.748031496062992)(.=sUa984251968503937)]351181102362204C."mA Y}/Gri dlineCoLmm@OxlBNoe Soriz"o`llyCTrudocVertE2Or& raiDra ftaper0SizeA4AFirstNumbbaxlAu;`VcxrY2Down{OverBlackAnd0WhitZoommFitP1`PsWidqMB TallGLveQfedUsMOut CopXiesR_pLlX:=uSub `nrU $`n(L %xME$Round5*__SRP_e'__SRP_f9gAverages; rU~|  D1 Y! I q  9 a q  A a 9 ! Q Qq Ay 1iQY!Q Q$D$pz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xhc kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%: %$ aht)T6xhm kzpz(D%($%T'X%:h%$ Tax(%(%'%: %$ aht)T6xh kzpzVkzD%(D%($%T'X%:h %$ T)T5pz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh& kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh0 kzpz(D%($%T'X%:h%$ Tax(%(%'%: %$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%: %$ aht)T6xh kzpzVkzD%(D%($%T'X%:h %$ T)T5pz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xhE kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%: %$ aht)T6xhO kzpz(D%($%T'X%:h%$ Tax(%(%'%: %$ aht)T6xh kzpzVkzD%(D%($%T'X%:h %$ T)T5pz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xhd kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%: %$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%: %$ aht)T6xhn kzpzVkzD%(D%($%T'X%:h%$ T)T5pz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xhy kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh' kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%: %$ aht)T6xh1 kzpz(D%($%T'X%:h%$ Tax(%(%'%: %$ aht)T6xh kzpzVkzD%(D%($%T'X%:h%$ T)T5pz(D%($%T'X%:h %$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h %$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h %$ Tax(%(%'%:%$ aht)T6xhF kzpz(D%($%T'X%:h %$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h %$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h %$ Tax(%(%'%: %$ aht)T6xhP kzpzVkzD%(D%($%T'X%:h%$ T)T5pz(D%($%T'X%:h %$ Tax(%(%'%:%$ aht)T6xh[ kzpz(D%($%T'X%:h %$ Tax(%(%'%:%$ aht)T6xh  kzpz(D%($%T'X%:h %$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h %$ Tax(%(%'%:%$ aht)T6xhe kzpz(D%($%T'X%:h %$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h %$ Tax(%(%'%: %$ aht)T6xh kzpzVkzD%(D%($%T'X%:h%$ T)T5(T'X%:h%$ TTT'X%:h%$ QTo%%'4%:D%$ Qo%%%(H%f(%% $ 6(T'X%:h%$ TT(T'X%:h%$ T0T(:h %T$ @TW!C"T5$h%T$ DT,T(T'X%:h#%$ TT%T$ @TW!qT:h$%lC%:h$%lC& q(:h %T$ @TW!C"T5%T$ @TW!qT:h'%lC(:h)%lC*:h$%lC+:h'%lC,:h)%lC-:h$%lC.; ~?T$ T /okh%lC0T; ~?T$ T /okh%lC1T; ~?T$ T /okh%lC2T; ~?T$ T /okh%lC3T;  `?T$ T /okh%lC4T;  `?T$ T /okh%lC5Tfh%lC6fh%lC7h%lC8 ch%lC9 ch%lC:h%lCfh%lC;h %lC<h%lC=h%lC>fh%lC?fh%lC@(h%lCA(h%lCB qZ '%cX%'%'%'$%(h%'4%'D%T$ DTaC hC)T5D$,0 TxhXkcro recorded 02/09/99 by Guy Bartle]@'a_r1$%b_r1$% a_r1  '$k0a_r1$%c_r1$%   'ka_r1$%d_r1$%   'ka_r1$%e_r1$%   'k(a_r1$%f_r1$%  'ka_r1$%g_r1$%  'kx ap_r1$,'b_r1$%a_r1$%  'kb_r1$%c_r1$%  'kb_r1$%d_r1$%  'k@b_r1$%e_r1$%  'kb_r1$%f_r1$%  'kb_r1$%g_r1$%  'k8 bp_r1$,'c_r1$%b_r1$%  'kc_r1$%a_r1$%  'kXc_r1$%d_r1$%  'kc_r1$%e_r1$%  'kc_r1$%f_r1$%  'kPc_r1$%g_r1$%  'k cp_r1$,'d_r1$%b_r1$%  'kpd_r1$%c_r1$%  'kd_r1$%a_r1$%   'eckd_r1$%e_r1$%   '%khd_r1$%f_r1$%   '%kd_r1$%g_r1$%   '%k dp_r1$,'e_r1$%b_r1$%   'k0e_r1$%c_r1$%   'ke_r1$%d_r1$%   'ke_r1$%a_r1$%   '%k(e_r1$%f_r1$%   '%ke_r1$%g_r1$%   '%kx ep_r1$,'f_r1$%b_r1$%   'kf_r1$%d($%xME86 LLL<<< `k`z%h@Px(08 <BX@hh @X @@T @D @4 @$ @ @ @( @X @ @p @ @ @H @ @ @ @x @0h @X @`H @x8 @( @ @ @ @( @P`@@ h(@`P@ 8lrx|0`XG7$*\Rffff*0L4590f34f*\R1*#2ac*\R1*#e8*\R1*#1c8*\R1*#94*\R1*#a2*\R1*#10*\R1*#1c4*\R1*#d7*\R1*#83*\R1*#56*\R1*#79*\R1*#50*\R1*#dc"   ,( X `hp<x <  <( hx< < (<0 p"V< < P`<h < < Xh<p "V< 8H<P < < @P<X < "V0<8 x< < (8<@ < < 0 @ "VH p <x   <    <(  h x <   <   ( <0  p  "V  <   <  P ` <h   <   <  X h <p   "V  <  8H<P < < @P<X < "V(0hH((( $( %(8@ H(P %p    ;;;;;0;H`hp x  Z  Round5 Macro& Mac_r1$%   'kf_r1$%d_r1$%   'k@f_r1$%e_r1$%   '%kf_r1$%a_r1$%   '%kf_r1$%g_r1$%   '%k8 fp_r1$,'g_r1$%b_r1$%   'kg_r1$%c_r1$%   'kXg_r1$%d_r1$%   'kg_r1$%e_r1$%   '%kg_r1$%a_r1$%   '%kPg_r1$%f_r1$%   '%k gp_r1$,H37:K43$B@H"I37$$ (&K37$* (, 0.24 86 B@"A1:M45$B@HM45$B@: $A$1:$M$45 <!>(@ B(DA2$B@H <!>9F9Hq $A$1:$M$45 <!>(@ <!>&c9J&r9L9N&c9P&r9R9T~? X%Z9V~? X%Z9\~? X%Z9^~? X%Z9` `? X%Z9b `? X%Z9d9f9h l9j9n9p r969t x9v |9z 9~9999q(  B!B@o Attribute VB_Name = "Round5" Sub 0() '8 Macro< recorded 02/09/99 by Guy Bart$leP  Dim points As Int@eger = 1 If Range("a_r1").Offset(0, 4) >bTheZnA Pm+YE`nd If $cc1$1d_1e_1f{gœp= ĊMFpӚPs`i]Z P_ ("Z P_ \ PW PbPg狡@ 8z _]+("Z P_ \ P_ \ P_ \ PW PcPqzP/?y {?PoDpc8pThenIf"bd_be_1a_16f81zpo D H37:K43Select{ ion.Sort Key1:=D I37"),@ Order@xlDescendPing,A 2E _ "KH @K Hea:=x@lGuessCustom:=1, MatchCase:=FalseA ient at+TopTpoBot .A1:M45L:Activate BeSheet.PageSet up.PrArea"$A$10:$M$ Window.ScrollRow A A"2!With.  Title""RColumn aA  .0Leftc9#&cC@4errpRighHI Footer   Margin ApplicG.InchesToPb(0.748031496062992)(.=sUa984251968503937)]351181102362204C."mA Y}/Gri dlineCoLmm@OxlBNoe Soriz"o`llyCTrudocVertE2Or& raiDra ftaper0SizeA4AFirstNumbbaxlAu;`VcxrY2Down{OverBlackAnd0WhitZoommFitP1`PsWidqMB TallGLveQfedUsMOut CopXiesR_pLlX:=uSub 6 LL<(<,<0<4<8<<<` `x0kp%`0(08 <Bm@Hl uc@x\ n.@X of@H @8 @4 qq@0 @8 @ @  @P @ @h @ @ @ @ @ @p @` rU~| D1 Y! I q  9 a q  A a 9 ! Q Qq Ay 1iQY!Q Q$D$pz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xhc kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%: %$ aht)T6xhm kzpz(D%($%T'X%:h%$ Tax(%(%'%: %$ aht)T6xh kzpzVkzD%(D%($%T'X%:h %$ T)T5pz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh& kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh0 kzpz(D%($%T'X%:h%$ Tax(%(%'%: %$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%: %$ aht)T6xh kzpzVkzD%(D%($%T'X%:h %$ T)T5pz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xhE kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%: %$ aht)T6xhO kzpz(D%($%T'X%:h%$ Tax(%(%'%: %$ aht)T6xh kzpzVkzD%(D%($%T'X%:h %$ T)T5pz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xhd kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%: %$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%: %$ aht)T6xhn kzpzVkzD%(D%($%T'X%:h%$ T)T5pz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xhy kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh' kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h%$ Tax(%(%'%: %$ aht)T6xh1 kzpz(D%($%T'X%:h%$ Tax(%(%'%: %$ aht)T6xh kzpzVkzD%(D%($%T'X%:h%$ T)T5pz(D%($%T'X%:h %$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h %$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h %$ Tax(%(%'%:%$ aht)T6xhF kzpz(D%($%T'X%:h %$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h %$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h %$ Tax(%(%'%: %$ aht)T6xhP kzpzVkzD%(D%($%T'X%:h%$ T)T5pz(D%($%T'X%:h %$ Tax(%(%'%:%$ aht)T6xh[ kzpz(D%($%T'X%:h %$ Tax(%(%'%:%$ aht)T6xh  kzpz(D%($%T'X%:h %$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h %$ Tax(%(%'%:%$ aht)T6xhe kzpz(D%($%T'X%:h %$ Tax(%(%'%:%$ aht)T6xh kzpz(D%($%T'X%:h %$ Tax(%(%'%: %$ aht)T6xh kzpzVkzD%(D%($%T'X%:h%$ T)T5(T'X%:h%$ TTT'X%:h%$ QTo%%'4%:D%$ Qo%%%(H%f(%% $ 6(T'X%:h%$ TT(T'X%:h%$ T0T(:h %T$ @TW!C"T5$h%T$ DT,T(T'X%:h#%$ TT%T$ @TW!qT:h$%lC%:h$%lC& q(:h %T$ @TW!C"T5%T$ @TW!qT:h'%lC(:h)%lC*:h$%lC+:h'%lC,:h)%lC-:h$%lC.; ~?T$ T /okh%lC0T; ~?T$ T /okh%lC1T; ~?T$ T /okh%lC2T; ~?T$ T /okh%lC3T;  `?T$ T /okh%lC4T;  `?T$ T /okh%lC5Tfh%lC6fh%lC7h%lC8 ch%lC9 ch%lC:h%lCfh%lC;h %lC<h%lC=h%lC>fh%lC?fh%lC@(h%lCA(h%lCB qZ '%cX%'%'%'$%(h%'4%'D%T$ DTaC hC)T5D$,0 TxhXk@(P @@@ @0 H@G7$*\Rffff*0F4590f34f*\R1*#2ac*\R1*#e8*\R1*#1c8*\R1*#94*\R1*#a2*\R1*#10*\R1*#1c4*\R1*#dc"   0( X `(hd((Z (8P ` Averages Macro) Macro recorded 17/09/99 by Mr G D BartleO3:U38$B@H#U4$$ (&O4$* , 0.24 86 B@"O1:V38$B@H } $O$1:$V$38 <!>(@' B!B@r1A2$B@HoAttribute VB_Name = "Averages" Sub 8() '@ Mac ro" recorded 17/09/99 by Mr G D BartleV  Range("O3:U38").Sel`ect  ion.Sort @Key1:=0U@4"), OjrxlDesce@nding,(2(O( _PT4 xlA3Header:=xlGuessCustom:=1,stchCase:= 'FalseientatV!TopToBotG<s1:VsActiveSheet.PSetup.PrintArea$O$1:$V$'@Windowe d!sOut Copies^AA2End d rU~| __SRP_2 g__SRP_3sgPrepare __SRP_4u1 1q  A a 9 Q! Q  (X'\%:l%$ XXX'\%:l%$ QXo %%4'8%:H%$ Q4o%%%(%f`%@%0 $ 0 06 (X'\%:l%$ XX(:l%X$ @XW CX5 Z '%'%'%'%'8%(l%'H%'\%X$ DXa 44 h)X45 (X'\%:l%$ XXL$ X40 krU $`nrU~| 0  kx%gJ%gJ%gJI20RwWindow.SmallSll Do@wn:=1142wKCR2KeR2_iER@?K#K͜_CmR$f4͜$F-R$ )oqq(omN3/!x]$3/!-n9_0-B44tLB4oO3:U.@.Sort KePy1:=$UPv, OPr@xlqending, Header:=xlGuess, _S>!sCus(tom?,tchCase:=FalsOrienta!Top`ToBotBA3:M= Cle@arConts{14:M>NA25:M(A36:FB3=__I_¨ Ur[?___B-2OOIO!_ 2U 4289A3/stdole f%\*\G{00020430-C 0046}#2.0#0#C:\WINDOWS\SYSTEM\STDOLE2.TLB# Automation^MSForms>SFErms3 DD452EE1-E08F-101A-8-02608C4 D0BB4Dsystem32\FM20.DLL#Microsoft : ] Ob Library/;D1t00}#:0#k0lyI xlPortraitDDraft: PaperSize xlPaperA4cFirstPageNumber% xlAutomatic@OrderAxlDownThenOver BlackAndWhiteZoomFitToPagesWideFitToPagesTallZSelectedSheetsPrintOut.Copies?Collate(Round2?Offset(Round3@(Round4A(Round5B(Averages xlAscending`(PrepareЉ ActiveCell FormulaR1C1S SmallScrolltmDown; ClearContents{CopyƿPaste CutCopyModeWorkbookk Worksheet_Defaultj @G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.3#0#CABCA03E69-6EA5-4052-9C27-F33DFFEE895XDOCUME~1\guy\LOCALSTem@p\VBE\DS.8exd: .E .`M ACOfficDO@ficB A02DF8D04C-5BFAgB-BDE5HTAA@42gPROGRAM FILES\MICROSOFT O@FFICE\M0SO97l# 8\.0l"B D%BThisWorkb@ookG TDh1sWkbok 2 HB1B-B,!%"B +BBSheet1G Se`*t1 as2 Round Run? ~   %!" 2' 2 2 \  3 3 3 3 D Tk7 4 4 4% 4 $U 5 5 5 5U 9Ave"v%@xME(6 << < `@p (Macro recorded 17/09/99 by Mr G D Bartle 14%HxG7$*\Rffff*0G4590f34f"   0( X `h& 8H`p(8P`x(@Phx 8H`p(8P`x(@PHh   ( @P hx     0@ Xh     0 @ X p        ( 8 P ` x          (  @ P  h x         8 P h           8 H  ` p        J( x Prepare Macro) Macro recorded 17/09/99 by Mr G D BartleA1$B@Hr1$League, division and term (B4$B@H, 030 (B5$B@H29 (B6$B@H28 (B7$B@H'27 (B8$B@H26 (I4$B@H25 (I5$B@H%24 (I6$B@H23 (I7$B@Hf_r122 (I8$B@H%21 (B15$B@H20 (%B16$B@H$19 (B17$B@H18 (r1B18$B@H17 (B19$B@H16 (I15$B@H,15 (I16$B@H%14 (I17$B@H13 (I18$B@Hg_r112 (I19$B@H11 (I20$B@H  BB@B26$B@Hx10 (B27$B@H9 (%B28$B@H$8 (B29$B@H7 (r1B30$B@H6 (I26$B@H5 (I27$B@H4 (I28$B@H3 (I29$B@H2 (I30$B@H1 (B37$B@H0 (B38$B@H-1 (B39$B@H-2 (B40$B@H-3 (B41$B@H-4 (O3:U38$B@HP4$$ (& 0.24 86 B@"A3:M8$B@H B@A14:M19$B@H B@A25:M30$B@H B@A36:F41$B@H B@B31$B@H B@I31$B@H B@B20$B@H B@I20$B@H B@B9$B@H B@I9$B@H B@B42$B@H B@A3$B@HTeam A (A4$B@H Shooter 1 (A4$B@H B@A5:A8$B@H <B@A5$B@H X( Shooter 2 (A6$B@H Shooter 3 (A7$B@H Shooter 4 (A8$B@H Shooter 5 (B3$B@HR1 (C3$B@HR2 (D3$B@HR3 (E3$B@HR4 (F3$B@HR5 (A3:F8$B@H B@H3$B@H <B@A14$B@H <B@H14$B@H <B@A25$B@H <B@H25$B@H <B@A36$B@H <B@H3$B@H X(Team B (A14$B@HTeam C (H14$B@HTeam D (A25$B@HTeam E (H25$B@HTeam F (A36$B@HTeam G (B11:F11$B@H B@I11:M11$B@H B@B22:F22$B@H B@I22:M22$B@H B@B33:F33$B@H B@I33:M33$B@H B@B44:F44$B@H B@H36:K43$B@HH37$$ & 0.24 86 B@" B(DA2$B@HoXPAttribute VB_Name = "Prepare" Sub 4() P.DescriptionxMacro recorded 17/09/99 by Mr G D BartlProcDataZInvoke _FuncZ \n14' '= o%x+  Range("A1").Select ActiveCell.Formu@laR1C1BLeague, diviszand termL(B4(30 5&T29 6'8 7U786IyI25IgImI3LI2I1YB1(;1g;1I1c1 Jjj ngdMJ%y@I%gJragesG$vSrhagsi2ro9R olPrepareGPr@p@62|@),!590f34f Round2K*y rU~~~~~~~~~~~~~~~~Q ^TCrBJ    a a ))a AAa YYa qqa  a a yiI9 VBAProject ThisWorkbookSheet1Round1Round2Round3Round4Round5AveragesPrepareF /C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLLVBA  i0F4C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXEExcel q@    ay  *\G{000204EF-0000-0000-C000-000000000046}#4.0#9#C:\PROGRA~1\COMMON~1\MICROS~1\VBA\VBA6\VBE6.DLL#Visual Basic For Applications*\G{00020813-0000-0000-C000-000000000046}#1.5#0#C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE#Microsoft Excel 11.0 Object Library*\G{00020430-0000-0000-C000-000000000046}#2.0#0#C:\WINDOWS\SYSTEM\STDOLE2.TLB#OLE Automation*\G{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0#C:\WINDOWS\system32\FM20.DLL#Microsoft Forms 2.0 Object Library*\G{BCA03E69-6EA5-4052-9C27-F33DFFEE8956}#2.0#0#C:\DOCUME~1\guy\LOCALS~1\Temp\VBE\MSForms.exd#Microsoft Forms 2.0 Object Library.E .`M *\G{2DF8D04C-5BFA-101B-BDE5-00AA0044DE52}#2.3#0#C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\MSO97.DLL#Microsoft Office 8.0 Object Library   G7% ThisWorkbook0=4590f34fThisWorkbook%- Sheet10M4590f3ef Sheet1% Round10H4590f34f Round1%0 Round20I4590f34f Round2H\ Round30J4590f34f Round3k7`D Round40K4590f34f Round4x$ Round50L4590f34f Round5$Averages0F4590f34fAveragesR Prepare0G4590f34fPrepare@|H0x`no=,Jbŧ&:6&LCڽ͸u@u]JޚW;)G~DP2,cODy1"NM_M:E+-I0PuJBG[5tq}eBt;' [\ 2 Excel+ VBAWin16~Win32MacVBA6# VBAProjectstdole`MSFormsCOfficeu ThisWorkbook| _Evaluate Sheet1(Round1>pointsRange  SelectionZSortKey1OOrder1o xlDescending>Key2POrder2pHeaderMxlGuessY OrderCustom| MatchCase Orientationw xlTopToBottomActivate| ActiveSheet%N PageSetup PrintAreaP ActiveWindow+ ScrollRow"PrintTitleRows1sPrintTitleColumns LeftHeader CenterHeaderD RightHeader LeftFooter CenterFooter RightFooter|S LeftMargin] Application*InchesToPointsI RightMargin[ TopMargini BottomMarginu HeaderMargin8 FooterMargin PrintHeadings)nPrintGridlines@ PrintCommentsxlPrintNoCommentsCenterHorizontallyCenterVertical0FC:\WINDOWS\SYSTEM\STDOLE2.TLBstdole  QP.E .`M C:\WINDOWS\system32\FM20.DLLMSForms 1`i>nR@'=V -C:\DOCUME~1\guy\LOCALS~1\Temp\VBE\MSForms.exd 1pL-[DR 2C:\PROGRAM FILES\MICROSOFT OFFICE\OFFICE\MSO97.DLLOffice !  a_r1FF FF b_r1 c_r1 d_r1 e_r1 f_r1 g_r1 ap_r1 bp_r1 cp_r1 dp_r1 ep_r1 fp_r1 gp_r1 H37:K43 I37 K37Key1 Order1Key2 Order2 HeaderOrderCustomZoomMatchCaseOrientationSort A1:M45 M45 $A$1:$M$45PageSetupPrintArea A2 PrintTitleRows "PrintTitleColumns &cLeftHeader &rCenterHeaderRightHeaderLeftFooterCenterFooterRightFooterFLeftMarginRightMarginTopMarginBottomMarginHeaderMarginFooterMarginPrintHeadingsPrintGridlinesPrintComments $CenterHorizontally  CenterVertically DraftPaperSizeFirstPageNumber OrderBlackAndWhiteFitToPagesWideFitToPagesTallF8F0rSHh?8 F E3 #DF Worksheet @ O3:U38 U4 O4 O1:V38 $O$1:$V$38(rU~} __SRP_1PROJECTwmPROJECT!SummaryInformation($     (Macro recorded 17/09/99 by Mr G D Bartle 14 yaThisWorkbookThisWorkbookSheet1Sheet1Round1Round1Round2Round2Round3Round3Round4Round4Round5Round5AveragesAveragesPreparePrepareID="{47CFF36F-611E-11D3-BAF0-444553540000}" Document=ThisWorkbook/&H00000000 Document=Sheet1/&H00000000 Module=Round1 Module=Round2 Module=Round3 Module=Round4 Module=Round5 Module=Averages Module=Prepare Name="VBAProject" HelpContextID="0" VersionCompatible32="393222000" CMG="ACAE0A200A900E900E900E900E" DPB="202286C987C987C9" GC="94963248D2BDD3BDD342" [Host Extender Info] &H00000001={3832D640-CF90-11CF-8E43-00A0C911005A};VBE;&H00000000 [Workspace] ThisWorkbook=0, 0, 0, 0, C Sheet1=88, 88, 503, 426, C Round1=-21, 86, 435, 432, C Round2=150, 37, 565, 375, C Round3=89, 443, 504, 781, C Round4=88, 88, 503, 426, C Round5=110, 110, 525, 448, Averages=132, 132, 547, 470, Prepare=-7, 173, 408, 511, Z Oh+'0HPh| Mr G D Bartle Guy BartleMicrosoft Excel@R;^@(v5@z;^՜.+,D՜.+,DocumentSummaryInformation8CompObjm PXd lt| ~ A_6a_r1a_r2ap_r1ap_r2b_r1b_r2bp_r1bp_r2c_r1c_r2cp_r1d_r1d_r2dp_r1e_r1e_r2ep_r1f_r1f_r2fp_r1g_r1gp_r1A_6!Print_Area  Worksheets Named Ranges 8@ _PID_HLINKSAlKhttp://www.guybartle.com/ F!Microsoft Office Excel WorksheetBiff8Excel.Sheet.89q