Best Practices

Document Sample
Best Practices Powered By Docstoc
					Best Practices                     Dublin Lawn Tennis Council
                                  Team Registration Procedures

                                    BEST PRACTICES!!!!
            Print the Team List Worksheet in Blank and give to your Club Captains
            to plan and record their teams in advance of getting the fixture sheets.
        1   You can fill in the Class and Section details when you get the fixture
            sheets or from the Website at www.dltc.net ( about two weeks before
            the league)
            Nominate all your Subs on Day 1. A little extra effort and planning up
        2
            front will save everyone time and hassle during the league
            Fill in all Team Captain contact details… it helps us and other team
        3
            captains when you need to be contacted
            Please give us e mail addresses… we can then get results to you each
        4
            week
        5   Give a printed copy of your subs lists to your team captains.
        6   Remember to check your final nominations before you send them to us.
            Remember to tell your team captains the order of nomination of your
            teams. It is amazing the number of teams that play in the wrong order
            the first week. We will check your match result sheets against the
        7
            nominated teams received. If a team is played in a different order to that
            nominated the Rules will apply i.e. Points lost for all events affected by
            wrong order of play!!
        8   If you have a problem read the procedures again and start again!!


                               Have Fun and enjoy the Leagues!!!
                                        Dublin Lawn Tennis Council
                                       Team Registration Procedures

     If you follow these procedures STEP by STEP your team registration sheets will be completed.
     You will need a basic understanding of MS Excel.
     A total of 12 teams registrations are included. This should cover the requirements for any Club
     When you receive/download this document for the first time, save it to your PC and then
     update the version on your PC
     Step 1 - Read these Procedures
     Step 2 - Read the Best Practices
     Step 3 - Follow the Procedures 1 to 19 below
     To Nominate your Teams:
1 Access the Tab 'Team List'
2 ONLY USE THE LINES HIGHLIGHTED IN YELLOW IF YOU HAVE A TEAM(s) IN CLASS 1.
  Input all the details of the 'Authorised Club Officer' at the bottom of this worksheet - Lines 19 -
3
  25
  Input the Team Number, Class and Section of each of your teams from the fixture sheets that
4 have been supplied by the Council or from the Website at www.dltc.net. Input teams in
  numerical order of merit
  Input the names of your players in the relevant columns as singles and doubles pairings in
5
  order of merit- Full names are mandatory
     Input the Team Captain Contact Details for each team. Please give all contact details as this
6
     helps us when we have to contact a team. E Mail Addresses are particularly helpful
7 DO NOT DELETE team lines that are not needed on the 'Team List'.
8 Remember to save the document if you are not able to complete all details at once
9 DO NOT USE CUT AND PASTE TO INPUT OR AMEND DETAILS ON THE TEAM LIST
   If you follow the above , your individual team registration sheets will be automatically
   completed. DO NOT ATTEMPT TO INPUT ANY DATA IN THE INDIVIDUAL TEAM SHEETS. THEY
10 ARE LOCKED AND PROTECTED. IF YOU NEED TO MAKE ANY AMENDMENTS TO THE TEAM
   REGISTRATION MAKE THE CHANGES ON THE 'TEAM LIST' SHEET AND THEY WILL BE
   AUTOMATICALLY CHANGED ON THE TEAM REGISTRATION SHEET
11 You can print the 'Team List' sheet as a single record of all your team nominations
12 REMEMBER TO SAVE THE DOCUMENT TO YOUR PC BEFORE SENDING IT TO THE COUNCIL

     To Nominate your Subs:
13 Access the appropriate Tab - Subs - Men
14 Input the names of your subs along with the lowest Class in which they may Sub
15 Sort your list into alphabetical order by SURNAME using the Data/Sort function in EXCEL
16 REMEMBER TO SAVE THE DOCUMENT TO YOUR PC BEFORE SENDING IT TO THE COUNCIL

     NOTE: You should register ALL your substitutes before the League commences. If you put a
17
     little effort into this at the start it will save problems and work for everyone during the league.

     To submit your teams and substitutes
18 Print the Subs Lists and each individual Team Reg Sheet and send by post to the DLTC
                                                OR
19 E Mail your fully completed Team Registrations to the DLTC at dltc@eircom.net

     Incorrectly completed registrations will be returned to the Club for correct completion
                                                                         Summer League



                                  X
                          Input from Fixture sheets

Team Tab Reference
                           Team                        No. 1       No 2
                            No.
                                    Class   Section                         No 3 Singles No 4 Singles No 5 Singles No 6 Singles
                                                      Singles     Singles
Premier Men         A
Class 1 Men         A1
Men                 B
Men                 C
Men                 D
Men                 E
Men                 F
Men                 G                                                                                   Class 1 Only
Men                 H
Men                  I
Men                  J
Men                 K
Men                 L

                                                                              Authorised Club Officer
                                                                Club                     X
                                                                Signed By
                                                                Club Position
                                                                Phone Home
                                                                Phone - Work
                                                                Phone - Mobile
                                                                E Mail




    Updated at: 11/12/20087:28 PM
                                                                            Summer League



                                  X
                          Input from Fixture sheets      No. 1 Doubles            No. 2 Doubles            No. 3 Doubles
Team Tab Reference
                           Team
                            No.
                                    Class   Section   Player 1   Player 2     Player 1      Player 2   Player 1     Player 2
Premier Men         A
Class 1 Men         A1
Men                 B
Men                 C
Men                 D
Men                 E
Men                 F
Men                 G                                                                                     Class 1 Only
Men                 H
Men                  I
Men                  J
Men                 K
Men                 L




    Updated at: 11/12/20087:28 PM
                                                                      Summer League



                                  X
                          Input from Fixture sheets                       Team Captain Contact Details
Team Tab Reference
                           Team
                            No.
                                    Class   Section   Team Captain   Home Tel    Work Tel    Mobile Tel   E Mail
Premier Men         A
Class 1 Men         A1
Men                 B
Men                 C
Men                 D
Men                 E
Men                 F
Men                 G
Men                 H
Men                  I
Men                  J
Men                 K
Men                 L




    Updated at: 11/12/20087:28 PM
     Subs -Men
                                                                     Summer League



      Club                                 X                                       For DLTC Office Use
                                               Lowest
          First Name             Surname
                                                Class   Week 1   Week 2   Week 3   Week 4   Week 5   R 16   QF   SF   F
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26




     Updated at: 11/12/20087:28 PM
     Subs -Men
                                                                     Summer League



      Club                                 X                                       For DLTC Office Use
                                               Lowest
          First Name             Surname
                                                Class   Week 1   Week 2   Week 3   Week 4   Week 5   R 16   QF   SF   F
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52




     Updated at: 11/12/20087:28 PM
     Subs -Men
                                                                     Summer League



      Club                                 X                                       For DLTC Office Use
                                               Lowest
          First Name             Surname
                                                Class   Week 1   Week 2   Week 3   Week 4   Week 5   R 16   QF   SF   F
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69




     Updated at: 11/12/20087:28 PM
Premier Men
                                            Summer League
                                Dublin Lawn Tennis Council
                                      Summer League
                                     Team Registration

  Club                                                          X
                                                          Premier Men
  Team No.                                  0
  Class                                     0
  Section                                   0

                                                            For DLTC Office Use Only
              Singles                                 1     2     3    4    5    SF    F
     1     0
     2     0
     3     0
     4     0
     5     0
     6     0
              Doubles
    1      0
           0
    2      0
           0
    3      0
           0
                          Team Captain Contact Details
  Team Captain Name                               0
  Home Phone                                      0
  Work Phone                                      0
  Mobile Phone                                    0
  E-Mail                                          0
                                  Club Contact Details
  Signed                                          0
  Club Position                                   0
  Phone - Home                                    0
  Phone Work                                      0
  Phone Mobile                                    0
  E - Mail                                        0




Updated at: 11/12/20087:28 PM
Class 1 Men Team A1
                                            Summer League
                                Dublin Lawn Tennis Council
                                      Summer League
                                     Team Registration

  Club                                                          X
                                                          Class 1 Men
  Team No.                                  0
  Class                                     0
  Section                                   0

                                                           For DLTC Office Use Only
            Singles                                   1     2    3    4    5    SF    F
     1     0
     2     0
     3     0
     4     0
     5     0
     6     0
            Doubles
    1      0
           0
    2      0
           0
    3      0
           0
                          Team Captain Contact Details
  Team Captain Name                               0
  Home Phone                                      0
  Work Phone                                      0
  Mobile Phone                                    0
  E-Mail                                          0
                                  Club Contact Details
  Signed                                          0
  Club Position                                   0
  Phone - Home                                    0
  Phone Work                                      0
  Phone Mobile                                    0
  E - Mail                                        0




Updated at: 11/12/20087:28 PM
Men Team B
                                             Summer League
                           Dublin Lawn Tennis Council
                                     Summer League
                                    Team Registration

  Club                                                    X
                                                          Men
  Team No.                               0
  Class                                  0
  Section                                0
                                                           For DLTC Office Use Only
          Singles                                 1   2    3    4     5 R16 QF SF     F
    1      0
    2      0
    3      0
         Doubles
           0
    1
           0
           0
    2
           0

                                Team Captain Contact Details
  Team Captain Name                           0
  Home Phone                                  0
  Work Phone                                  0
  Mobile Phone                                0
  E-Mail                                      0
                                    Club Contact Details
  Signed                                      0
  Club Position                               0
  Phone - Home                                0
  Phone Work                                  0
  Phone Mobile                                0
  E - Mail                                    0




Updated at: 11/12/20087:28 PM
Men Team C
                                             Summer League
                           Dublin Lawn Tennis Council
                                     Summer League
                                    Team Registration

  Club                                                    X
                                                          Men
  Team No.                               0
  Class                                  0
  Section                                0
                                                           For DLTC Office Use Only
          Singles                                 1   2    3    4     5 R16 QF SF     F
    1      0
    2      0
    3      0
         Doubles
           0
    1
           0
           0
    2
           0

                                Team Captain Contact Details
  Team Captain Name                           0
  Home Phone                                  0
  Work Phone                                  0
  Mobile Phone                                0
  E-Mail                                      0
                                    Club Contact Details
  Signed                                      0
  Club Position                               0
  Phone - Home                                0
  Phone Work                                  0
  Phone Mobile                                0
  E - Mail                                    0




Updated at: 11/12/20087:28 PM
Men Team D
                                             Summer League
                           Dublin Lawn Tennis Council
                                     Summer League
                                    Team Registration

  Club                                                    X
                                                          Men
  Team No.                               0
  Class                                  0
  Section                                0
                                                           For DLTC Office Use Only
          Singles                                 1   2    3    4     5 R16 QF SF     F
    1      0
    2      0
    3      0
         Doubles
           0
    1
           0
           0
    2
           0

                                Team Captain Contact Details
  Team Captain Name                           0
  Home Phone                                  0
  Work Phone                                  0
  Mobile Phone                                0
  E-Mail                                      0
                                    Club Contact Details
  Signed                                      0
  Club Position                               0
  Phone - Home                                0
  Phone Work                                  0
  Phone Mobile                                0
  E - Mail                                    0




Updated at: 11/12/20087:28 PM
Men Team E
                                             Summer League
                           Dublin Lawn Tennis Council
                                     Summer League
                                    Team Registration

  Club                                                    X
                                                          Men
  Team No.                               0
  Class                                  0
  Section                                0
                                                           For DLTC Office Use Only
          Singles                                 1   2    3    4     5 R16 QF SF     F
    1      0
    2      0
    3      0
         Doubles
           0
    1
           0
           0
    2
           0

                                Team Captain Contact Details
  Team Captain Name                           0
  Home Phone                                  0
  Work Phone                                  0
  Mobile Phone                                0
  E-Mail                                      0
                                    Club Contact Details
  Signed                                      0
  Club Position                               0
  Phone - Home                                0
  Phone Work                                  0
  Phone Mobile                                0
  E - Mail                                    0




Updated at: 11/12/20087:28 PM
Men Team F
                                             Summer League
                           Dublin Lawn Tennis Council
                                     Summer League
                                    Team Registration

  Club                                                    X
                                                          Men
  Team No.                               0
  Class                                  0
  Section                                0
                                                           For DLTC Office Use Only
          Singles                                 1   2    3    4     5 R16 QF SF     F
    1      0
    2      0
    3      0
         Doubles
           0
    1
           0
           0
    2
           0

                                Team Captain Contact Details
  Team Captain Name                           0
  Home Phone                                  0
  Work Phone                                  0
  Mobile Phone                                0
  E-Mail                                      0
                                    Club Contact Details
  Signed                                      0
  Club Position                               0
  Phone - Home                                0
  Phone Work                                  0
  Phone Mobile                                0
  E - Mail                                    0




Updated at: 11/12/20087:28 PM
Men Team G
                                             Summer League
                           Dublin Lawn Tennis Council
                                     Summer League
                                    Team Registration

  Club                                                    X
                                                          Men
  Team No.                               0
  Class                                  0
  Section                                0
                                                           For DLTC Office Use Only
          Singles                                 1   2    3    4     5 R16 QF SF     F
    1      0
    2      0
    3      0
         Doubles
           0
    1
           0
           0
    2
           0

                                Team Captain Contact Details
  Team Captain Name                           0
  Home Phone                                  0
  Work Phone                                  0
  Mobile Phone                                0
  E-Mail                                      0
                                    Club Contact Details
  Signed                                      0
  Club Position                               0
  Phone - Home                                0
  Phone Work                                  0
  Phone Mobile                                0
  E - Mail                                    0




Updated at: 11/12/20087:28 PM
Men Team H
                                             Summer League
                           Dublin Lawn Tennis Council
                                     Summer League
                                    Team Registration

  Club                                                    X
                                                          Men
  Team No.                               0
  Class                                  0
  Section                                0
                                                           For DLTC Office Use Only
          Singles                                 1   2    3    4     5 R16 QF SF     F
    1      0
    2      0
    3      0
         Doubles
           0
    1
           0
           0
    2
           0

                                Team Captain Contact Details
  Team Captain Name                           0
  Home Phone                                  0
  Work Phone                                  0
  Mobile Phone                                0
  E-Mail                                      0
                                    Club Contact Details
  Signed                                      0
  Club Position                               0
  Phone - Home                                0
  Phone Work                                  0
  Phone Mobile                                0
  E - Mail                                    0




Updated at: 11/12/20087:28 PM
Men Team I
                                             Summer League
                           Dublin Lawn Tennis Council
                                     Summer League
                                    Team Registration

  Club                                                    X
                                                          Men
  Team No.                               0
  Class                                  0
  Section                                0
                                                           For DLTC Office Use Only
          Singles                                 1   2    3    4     5 R16 QF SF     F
    1        0
    2        0
    3        0
         Doubles
             0
    1
             0
             0
    2
             0

                                Team Captain Contact Details
  Team Captain Name                           0
  Home Phone                                  0
  Work Phone                                  0
  Mobile Phone                                0
  E-Mail                                      0
                                    Club Contact Details
  Signed                                      0
  Club Position                               0
  Phone - Home                                0
  Phone Work                                  0
  Phone Mobile                                0
  E - Mail                                    0




Updated at: 11/12/20087:28 PM
Men Team J
                                             Summer League
                           Dublin Lawn Tennis Council
                                     Summer League
                                    Team Registration

  Club                                                    X
                                                          Men
  Team No.                               0
  Class                                  0
  Section                                0
                                                           For DLTC Office Use Only
          Singles                                 1   2    3    4     5 R16 QF SF     F
    1      0
    2      0
    3      0
         Doubles
           0
    1
           0
           0
    2
           0

                                Team Captain Contact Details
  Team Captain Name                           0
  Home Phone                                  0
  Work Phone                                  0
  Mobile Phone                                0
  E-Mail                                      0
                                    Club Contact Details
  Signed                                      0
  Club Position                               0
  Phone - Home                                0
  Phone Work                                  0
  Phone Mobile                                0
  E - Mail                                    0




Updated at: 11/12/20087:28 PM
Men Team K
                                             Summer League
                           Dublin Lawn Tennis Council
                                     Summer League
                                    Team Registration

  Club                                                    X
                                                          Men
  Team No.                               0
  Class                                  0
  Section                                0
                                                           For DLTC Office Use Only
          Singles                                 1   2    3    4     5 R16 QF SF     F
    1      0
    2      0
    3      0
         Doubles
           0
    1
           0
           0
    2
           0

                                Team Captain Contact Details
  Team Captain Name                           0
  Home Phone                                  0
  Work Phone                                  0
  Mobile Phone                                0
  E-Mail                                      0
                                    Club Contact Details
  Signed                                      0
  Club Position                               0
  Phone - Home                                0
  Phone Work                                  0
  Phone Mobile                                0
  E - Mail                                    0




Updated at: 11/12/20087:28 PM
Men Team L
                                             Summer League
                           Dublin Lawn Tennis Council
                                     Summer League
                                    Team Registration

  Club                                                    X
                                                          Men
  Team No.                               0
  Class                                  0
  Section                                0
                                                           For DLTC Office Use Only
          Singles                                 1   2    3    4     5 R16 QF SF     F
    1      0
    2      0
    3      0
         Doubles
           0
    1
           0
           0
    2
           0

                                Team Captain Contact Details
  Team Captain Name                           0
  Home Phone                                  0
  Work Phone                                  0
  Mobile Phone                                0
  E-Mail                                      0
                                    Club Contact Details
  Signed                                      0
  Club Position                               0
  Phone - Home                                0
  Phone Work                                  0
  Phone Mobile                                0
  E - Mail                                    0




Updated at: 11/12/20087:28 PM

				
DOCUMENT INFO