Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Click Cells on the Format menu by GuJc2W

VIEWS: 4 PAGES: 21

									                                                 teams


Team#            Team
   1    Auburn
   2    Clemson
   3    Eastern Kentucky
   4    Georgia
   5    Kentucky
   6    Murray State
   7    Tennessee Knoxville
   8    Tennessee Tech
   9    Tennessee Martin
  10    Virginia Tech
  11    West Virginia
  12    Western Kentucky
  13    North Carolina State

        This is almost alphabetical. But each year, the host team should move to the bottom, and the rest scrambled.
        In this example, the host team was NCSU and they did not score any pits.




                                                 Page 1
                                teams




ttom, and the rest scrambled.




                                Page 2
Team number   Team                Team # Letter        Student
     1        Auburn                1      a        Taylor Boozer
     1        Auburn                1      b        Jacob Hodnett       1. Select the entire worksheet by clicking the S
     1        Auburn                1      c        Michael Gunn        2. Click Cells on the Format menu, click the P
     1        Auburn                1      d        Brad Kirkeland
     1        Auburn                1      e         Daniel Goins       This unlocks all the cells on the worksheet
     1        Auburn                1      f          Hal Darsey
     1        Auburn                1      g         Amy Weaver         Note If the Cells command is not available, p
     1        Auburn                1      h
     2        Clemson               2      a         Mark Dowtin        3. Select just the cells you want to lock and rep
     2        Clemson               2      b         Jesse Harris       4. On the Tools menu, point to Protection, cli
     2        Clemson               2      c      Russell Henderson
     2        Clemson               2      d      Tyler Hollingsworth   Note In the Protect Sheet dialog box, you hav
     2        Clemson               2      e
     2        Clemson               2      f
     2        Clemson               2      g
     2        Clemson               2      h
     3        Eastern Kentucky      3      a         Ryan Reams
     3        Eastern Kentucky      3      b          Holly Short
     3        Eastern Kentucky      3      c        Jamie Newton
     3        Eastern Kentucky      3      d          Josh Davis
     3        Eastern Kentucky      3      e         Ruth Rogers
     3        Eastern Kentucky      3      f         Dustin Gum
     3        Eastern Kentucky      3      g         Grant Lucas
     3        Eastern Kentucky      3      h         Justin Jump
     4        Georgia               4      a         Andrew Croy
     4        Georgia               4      b        Tony DeMarco
     4        Georgia               4      c        Charles Moore
     4        Georgia               4      d       Brandon Stuart
     4        Georgia               4      e        Kristin Abney
     4        Georgia               4      f       Gus McCormick
     4        Georgia               4      g       Anthony McEver
     4        Georgia               4      h
     5        Kentucky              5      a       Paul Shumaker
     5        Kentucky              5      b          Jesse Horn
     5        Kentucky              5      c         Paul Blanche
     5        Kentucky              5      d       Vincent Madigan
     5        Kentucky              5      e        Daisy Fryman
     5        Kentucky              5      f
     5        Kentucky              5      g
     5        Kentucky              5      h
     6        Murray State          6      a       Jarrod L.Hankins
     6        Murray State          6      b      Benjamin Rowland
     6        Murray State          6      c        Lauren E. Omer
     6        Murray State          6      d         Cody R. Smith
     6        Murray State          6      e       Kristine M. Brown
     6        Murray State          6      f      James B. Stratton
     6        Murray State          6      g       Dane T. Weaver
     6        Murray State          6      h       Jeremy N. Huge
     7        Tennessee Knoxville   7      a      Andrew Henderson
     7        Tennessee Knoxville   7      b           Ryan Blair
     7        Tennessee Knoxville   7      c        Brian Chomicki
 7   Tennessee Knoxville    7   d      Brian Lester
 7   Tennessee Knoxville    7   e     Katie Gassaway
 7   Tennessee Knoxville    7   f
 7   Tennessee Knoxville    7   g
 7   Tennessee Knoxville    7   h
 8   Tennessee Tech         8   a     Josh Hatchett
 8   Tennessee Tech         8   b       Daniel Hall
 8   Tennessee Tech         8   c        Liz Miller
 8   Tennessee Tech         8   d   Andrzej Kaslikowski
 8   Tennessee Tech         8   e      Ben Wiggins
 8   Tennessee Tech         8   f   Debbie Eskandarnia
 8   Tennessee Tech         8   g
 8   Tennessee Tech         8   h
 9   Tennessee Martin       9   a    Joseph Morrissett
 9   Tennessee Martin       9   b    Hunter Stephens
 9   Tennessee Martin       9   c      Kevin Smith
 9   Tennessee Martin       9   d
 9   Tennessee Martin       9   e
 9   Tennessee Martin       9   f
 9   Tennessee Martin       9   g
 9   Tennessee Martin       9   h
10   Virginia Tech         10   a       Carlin Conk
10   Virginia Tech         10   b      Caroline Park
10   Virginia Tech         10   c      Dylan Walker
10   Virginia Tech         10   d       Lisa Moore
10   Virginia Tech         10   e       Nick Haus
10   Virginia Tech         10   f   Shenandoah McGrath
10   Virginia Tech         10   g    Bobby Drumheller
10   Virginia Tech         10   h
11   West Virginia         11   a    Jonathan Hopkins
11   West Virginia         11   b       Kim Godbey
11   West Virginia         11   c      Jared Wilmoth
11   West Virginia         11   d       Randy Riddle
11   West Virginia         11   e       Adam Boner
11   West Virginia         11   f     Corry Calderone
11   West Virginia         11   g      Justin Barnes
11   West Virginia         11   h        Kent Smith
12   Western Kentucky      12   a        Matt Futrell
12   Western Kentucky      12   b       Robin Dalton
12   Western Kentucky      12   c       Darren Tabor
12   Western Kentucky      12   d        Josh Lauria
12   Western Kentucky      12   e       Lacey Geary
12   Western Kentucky      12   f      Christie Goley
12   Western Kentucky      12   g      Adam Massey
12   Western Kentucky      12   h         Alan Moss
ntire worksheet by clicking the Select All button (the gray rectangle directly above the row number for row 1 and to the left of column letter A
on the Format menu, click the Protection tab, and then clear the Locked check box.

l the cells on the worksheet

lls command is not available, parts of the worksheet may already be locked. On the Tools menu, point to Protection, and then click Unpro

he cells you want to lock and repeat step 2, but this time select the Locked check box.
s menu, point to Protection, click Protect Sheet, and then click OK.

otect Sheet dialog box, you have the option to specify a password and select the elements that you want users to be able to change. See Pro
w 1 and to the left of column letter A).




to Protection, and then click Unprotect Sheet.




t users to be able to change. See Protect worksheet or workbook elements for more information.
                                                           Site        Site       Site      Site
                                                            1            2         3         4
Team# Letter Team               Student                   yellow      orange     green      red
  1     a Auburn                Taylor Boozer                   176        159        162       118
  1     b Auburn                Jacob Hodnett                   167        179        159       142
  1     c Auburn                Michael Gunn                    165        130        156       124
  1     d Auburn                Brad Kirkeland                  178        158        127        98
  1     e Auburn                Daniel Goins                    178        153        154       103
  1     f    Auburn             Hal Darsey                      176        148        153        98
  1     g Auburn                Amy Weaver                      143        123        157       133
  1     h Auburn                                      0
  2     a Clemson               Mark Dowtin                    154        107        121       121
  2     b Clemson               Jesse Harris                   142        117        137       108
  2     c Clemson               Russell Henderson              151        128        153       100
  2     d Clemson               Tyler Hollingsworth            159        126        150       112
  2     e Clemson                                     0
  2     f    Clemson                                  0
  2     g Clemson                                     0
  2     h Clemson                                     0
  3     a Eastern Kentucky      Ryan Reams                     126        142        126       113
  3     b Eastern Kentucky      Holly Short                    143        129        124        97
  3     c Eastern Kentucky      Jamie Newton                   129        110        139        59
  3     d Eastern Kentucky      Josh Davis                     125         96        125       100
  3     e Eastern Kentucky      Ruth Rogers                    120        112        109        83
  3     f    Eastern Kentucky   Dustin Gum                     127        110        122        75
  3     g Eastern Kentucky      Grant Lucas                    132         84        114        69
  3     h Eastern Kentucky      Justin Jump                    104         83         89        60
  4     a Georgia               Andrew Croy                    164        175        154       137
  4     b Georgia               Tony DeMarco                   173        147        136       112
  4     c Georgia               Charles Moore                  177        155        162        99
  4     d Georgia               Brandon Stuart                 161        147        143       130
  4     e Georgia               Kristin Abney                  148        125        136       107
  4     f    Georgia            Gus McCormick                  171        157        146       137
  4     g Georgia               Anthony McEver                 153        161        141       110
  4     h Georgia                                     0
  5     a Kentucky              Paul Shumaker                  180        157        148       130
  5     b Kentucky              Jesse Horn                     161        142        125       110
  5     c Kentucky              Paul Blanche                   173        156        147       105
  5     d Kentucky              Vincent Madigan                146        142        160       111
  5     e Kentucky              Daisy Fryman                   147        145        134        95
  5     f    Kentucky                                 0
  5     g Kentucky                                    0
  5     h Kentucky                                    0
  6     a Murray State          Jarrod L.Hankins               145        144        127       117
  6     b Murray State          Benjamin Rowland               157        143        146       120
  6     c Murray State          Lauren E. Omer                 140        130        146       117
  6     d Murray State          Cody R. Smith                  133        119        134       101
  6     e Murray State          Kristine M. Brown              127        113        162        95
  6     f    Murray State       James B. Stratton              144        125        168        91
  6     g Murray State          Dane T. Weaver                 135        133        140        96
  6     h Murray State          Jeremy N. Huge                 122        123        111        72
  7     a Tennessee Knoxville   Andrew Henderson               120        111        134        97
 7   b   Tennessee Knoxville   Ryan Blair                137   120   121    94
 7   c   Tennessee Knoxville   Brian Chomicki            136   119   156   105
 7   d   Tennessee Knoxville   Brian Lester              152   161   155    98
 7   e   Tennessee Knoxville   Katie Gassaway            159   138   128   106
 7   f   Tennessee Knoxville                         0
 7   g   Tennessee Knoxville                         0
 7   h   Tennessee Knoxville                         0
 8   a   Tennessee Tech        Josh Hatchett             144   145   121   122
 8   b   Tennessee Tech        Daniel Hall               164   146   162   111
 8   c   Tennessee Tech        Liz Miller                150   147   147    92
 8   d   Tennessee Tech        Andrzej Kaslikowski       149   142   156   115
 8   e   Tennessee Tech        Ben Wiggins               147   125   124    86
 8   f   Tennessee Tech        Debbie Eskandarnia        136    97   126    96
 8   g   Tennessee Tech                              0
 8   h   Tennessee Tech                              0
 9   a   Tennessee Martin      Joseph Morrissett         153   126   162   100
 9   b   Tennessee Martin      Hunter Stephens           146   124   142   106
 9   c   Tennessee Martin      Kevin Smith               158   124   143    69
 9   d   Tennessee Martin                            0     0     0     0     0
 9   e   Tennessee Martin                            0
 9   f   Tennessee Martin                            0
 9   g   Tennessee Martin                            0
 9   h   Tennessee Martin                            0
10   a   Virginia Tech         Carlin Conk               169   181   144   117
10   b   Virginia Tech         Caroline Park             164   156   146   104
10   c   Virginia Tech         Dylan Walker              170   165   152   120
10   d   Virginia Tech         Lisa Moore                165   160   151   122
10   e   Virginia Tech         Nick Haus                 149   139   144   130
10   f   Virginia Tech         Shenandoah McGrath        164   139   139   100
10   g   Virginia Tech         Bobby Drumheller          160   116   163   104
10   h   Virginia Tech                           0
11   a   West Virginia         Jonathan Hopkins          168   141   136   124
11   b   West Virginia         Kim Godbey                159   140   150   115
11   c   West Virginia         Jared Wilmoth             161   150   148   138
11   d   West Virginia         Randy Riddle              148   137   145   107
11   e   West Virginia         Adam Boner                154   153   138   145
11   f   West Virginia         Corry Calderone           166   157   146   132
11   g   West Virginia         Justin Barnes             156   114   156   107
11   h   West Virginia         Kent Smith                137   134   143   125
12   a   Western Kentucky      Matt Futrell              160   152   150   100
12   b   Western Kentucky      Robin Dalton              136   123   140    93
12   c   Western Kentucky      Darren Tabor              173   119   151   115
12   d   Western Kentucky      Josh Lauria               140   139   156   116
12   e   Western Kentucky      Lacey Geary               145   137   128   107
12   f   Western Kentucky      Christie Goley            149   122   134   105
12   g   Western Kentucky      Adam Massey               143   113   125   100
12   h   Western Kentucky      Alan Moss                 124   115   107   106
             Team #             team site totals
Individual                  1            2          3     4
  Total
       615
       647
       575
       561            1   521          496         477   384
       588
       575                                                     Each entry in columns E to H
       556                                                     must be double-checked
         0                                                     for entry errors.
       503
       504                                                      1. Select the entire worksheet by clicking the Select All
       532                                                      2. Click Cells on the Format menu, click the Protection
       547            2   464          371         440   341
         0                                                      This unlocks all the cells on the worksheet
         0
         0                                                      Note If the Cells command is not available, parts of the
         0
       507                                                      3. Select just the cells you want to lock and repeat step
       493                                                      4. On the Tools menu, point to Protection, click Protec
       437
       446            3   398          381         390   310    Note In the Protect Sheet dialog box, you have the optio
       424
       434
       399
       336
       630
       568
       593
       581            4   514          477         459   379
       516
       611
       565
         0
       615
       538
       581
       559            5   514          455         455   351
       521
         0
         0
         0
       533
       566
       533
       487            6   442          417         426   354
       497
       528
       504
       428
       462
472
516
566   7    425   400   445   300
531
  0
  0
  0
532
583
536
562   8    463   438   465   348
482
455
  0
  0
541
518
494
  0   9    457   374   447   275
  0
  0
  0
  0
611
570
607
598   10   504   506   449   359
562
542
543
  0
569
564
597
537   11   488   431   443   377
590
601
533
539
562
492
558
551   12   473   414   457   331
517
510
481
452
worksheet by clicking the Select All button (the gray rectangle directly above the row number for row 1 and to the left of column letter A).
e Format menu, click the Protection tab, and then clear the Locked check box.

 cells on the worksheet

ommand is not available, parts of the worksheet may already be locked. On the Tools menu, point to Protection, and then click Unprotect

 lls you want to lock and repeat step 2, but this time select the Locked check box.
enu, point to Protection, click Protect Sheet, and then click OK.

 Sheet dialog box, you have the option to specify a password and select the elements that you want users to be able to change. See Protect
and to the left of column letter A).




otection, and then click Unprotect Sheet.




rs to be able to change. See Protect worksheet or workbook elements for more information.
                                   Site       Site        Site       Site
Team#           Team                1          2           3          4                     Total
   1    Auburn                     521        496         477        384                    1878
   2    Clemson                    464        371         440        341                    1616
   3    Eastern Kentucky           398        381         390        310                    1479
   4    Georgia                    514        477         459        379                    1829
   5    Kentucky                   514        455         455        351                    1775
   6    Murray State               442        417         426        354                    1639
   7    Tennessee Knoxville        425        400         445        300                    1570
   8    Tennessee Tech             463        438         465        348                    1714
   9    Tennessee Martin           457        374         447        275                    1553
  10    Virginia Tech              504        506         449        359                    1818
  11    West Virginia              488        431         443        377                    1739
  12    Western Kentucky           473        414         457        331                    1675

        Copy what is in the box, then use "paste special" and select "values" to place on the team_final page, then s
        names, and all scores and "sort" by the Total column in descending order.
n the team_final page, then select the team number,
                                       Site        Site        Site          Site   Team
Team Rank      Team                     1           2           3             4     Total
    1       Auburn                     521         496         477           384    1878
    2       Georgia                    514         477         459           379    1829
    3       Virginia Tech              504         506         449           359    1818
    4       Kentucky                   514         455         455           351    1775
    5       West Virginia              488         431         443           377    1739
    6       Tennessee Tech             463         438         465           348    1714
    7       Western Kentucky           473         414         457           331    1675
    8       Murray State               442         417         426           354    1639
    9       Clemson                    464         371         440           341    1616
   10       Tennessee Knoxville        425         400         445           300    1570
   11       Tennessee Martin           457         374         447           275    1553
   12       Eastern Kentucky           398         381         390           310    1479

            Paste into the box
            This is the sorted data that can be presented as final results
            Sort what is inside the box after pasting values.
Team #   Letter            Team                  Student       1     2     3     4 Total   Rank
   1       b      Auburn                Jacob Hodnett         167   179   159   142 647      1
   4       a      Georgia               Andrew Croy           164   175   154   137 630      2
   1       a      Auburn                Taylor Boozer         176   159   162   118 615      3
   5       a      Kentucky              Paul Shumaker         180   157   148   130 615      4
   4       f      Georgia               Gus McCormick         171   157   146   137 611      5
  10       a      Virginia Tech         Carlin Conk           169   181   144   117 611      6
  10       c      Virginia Tech         Dylan Walker          170   165   152   120 607      7
  11       f      West Virginia         Corry Calderone       166   157   146   132 601      8
  10       d      Virginia Tech         Lisa Moore            165   160   151   122 598      9
  11       c      West Virginia         Jared Wilmoth         161   150   148   138 597     10
   4       c      Georgia               Charles Moore         177   155   162    99 593     11
  11       e      West Virginia         Adam Boner            154   153   138   145 590     12
   1       e      Auburn                Daniel Goins          178   153   154   103 588     13
   8       b      Tennessee Tech        Daniel Hall           164   146   162   111 583     14
   4       d      Georgia               Brandon Stuart        161   147   143   130 581     15
   5       c      Kentucky              Paul Blanche          173   156   147   105 581     16
   1       c      Auburn                Michael Gunn          165   130   156   124 575     17
   1       f      Auburn                Hal Darsey            176   148   153    98 575     18
  10       b      Virginia Tech         Caroline Park         164   156   146   104 570     19
  11       a      West Virginia         Jonathan Hopkins      168   141   136   124 569     20
   4       b      Georgia               Tony DeMarco          173   147   136   112 568     21
   6       b      Murray State          Benjamin Rowland      157   143   146   120 566     22
   7       d      Tennessee Knoxville   Brian Lester          152   161   155    98 566     23
   4       g      Georgia               Anthony McEver        153   161   141   110 565     24
  11       b      West Virginia         Kim Godbey            159   140   150   115 564     25
   8       d      Tennessee Tech        Andrzej Kaslikowski   149   142   156   115 562     26
  10       e      Virginia Tech         Nick Haus             149   139   144   130 562     27
  12       a      Western Kentucky      Matt Futrell          160   152   150   100 562     28
   1       d      Auburn                Brad Kirkeland        178   158   127    98 561     29
   5       d      Kentucky              Vincent Madigan       146   142   160   111 559     30
  12       c      Western Kentucky      Darren Tabor          173   119   151   115 558     31
   1       g      Auburn                Amy Weaver            143   123   157   133 556     32
  12       d      Western Kentucky      Josh Lauria           140   139   156   116 551     33
   2       d      Clemson               Tyler Hollingsworth   159   126   150   112 547     34
  10       g      Virginia Tech         Bobby Drumheller      160   116   163   104 543     35
  10       f      Virginia Tech         Shenandoah McGrath    164   139   139   100 542     36
   9       a      Tennessee Martin      Joseph Morrissett     153   126   162   100 541     37
  11       h      West Virginia         Kent Smith            137   134   143   125 539     38
   5       b      Kentucky              Jesse Horn            161   142   125   110 538     39
  11       d      West Virginia         Randy Riddle          148   137   145   107 537     40
   8       c      Tennessee Tech        Liz Miller            150   147   147    92 536     41
   6       a      Murray State          Jarrod L.Hankins      145   144   127   117 533     42
   6       c      Murray State          Lauren E. Omer        140   130   146   117 533     43
  11       g      West Virginia         Justin Barnes         156   114   156   107 533     44
   2       c      Clemson               Russell Henderson     151   128   153   100 532     45
   8       a      Tennessee Tech        Josh Hatchett         144   145   121   122 532     46
   7       e      Tennessee Knoxville   Katie Gassaway        159   138   128   106 531     47
   6       f      Murray State          James B. Stratton     144   125   168    91 528     48
   5       e      Kentucky              Daisy Fryman          147   145   134    95 521     49
   9       b      Tennessee Martin      Hunter Stephens       146   124   142   106 518     50
Team #   Letter           Team                   Student      1     2     3     4 Total   Rank
  12       e      Western Kentucky      Lacey Geary          145   137   128   107 517     51
   4       e      Georgia               Kristin Abney        148   125   136   107 516     52
   7       c      Tennessee Knoxville   Brian Chomicki       136   119   156   105 516     53
  12       f      Western Kentucky      Christie Goley       149   122   134   105 510     54
   3       a      Eastern Kentucky      Ryan Reams           126   142   126   113 507     55
   2       b      Clemson               Jesse Harris         142   117   137   108 504     56
   6       g      Murray State          Dane T. Weaver       135   133   140    96 504     57
   2       a      Clemson               Mark Dowtin          154   107   121   121 503     58
   6       e      Murray State          Kristine M. Brown    127   113   162    95 497     59
   9       c      Tennessee Martin      Kevin Smith          158   124   143    69 494     60
   3       b      Eastern Kentucky      Holly Short          143   129   124    97 493     61
  12       b      Western Kentucky      Robin Dalton         136   123   140    93 492     62
   6       d      Murray State          Cody R. Smith        133   119   134   101 487     63
   8       e      Tennessee Tech        Ben Wiggins          147   125   124    86 482     64
  12       g      Western Kentucky      Adam Massey          143   113   125   100 481     65
   7       b      Tennessee Knoxville   Ryan Blair           137   120   121    94 472     66
   7       a      Tennessee Knoxville   Andrew Henderson     120   111   134    97 462     67
   8       f      Tennessee Tech        Debbie Eskandarnia   136    97   126    96 455     68
  12       h      Western Kentucky      Alan Moss            124   115   107   106 452     69
   3       d      Eastern Kentucky      Josh Davis           125    96   125   100 446     70
   3       c      Eastern Kentucky      Jamie Newton         129   110   139    59 437     71
   3       f      Eastern Kentucky      Dustin Gum           127   110   122    75 434     72
   6       h      Murray State          Jeremy N. Huge       122   123   111    72 428     73
   3       e      Eastern Kentucky      Ruth Rogers          120   112   109    83 424     74
   3       g      Eastern Kentucky      Grant Lucas          132    84   114    69 399     75
   3       h      Eastern Kentucky      Justin Jump          104    83    89    60 336     76
Copy columns A to I from sheet
data entry             In the box,
Paste special as values then
sort descending just as for the
team_final sheet.
The Rank column remains in
place.

								
To top