cauldron sheets by HC121004042910

VIEWS: 7 PAGES: 5

									      Weighting(1,2,3)               1         1          2
      Target(High/Low)       High        Low       High


Cauldron Ranking Points
Volleyball
03 Oct 2012
                                     0         1       0      0   0   0
Rank Last Name First Name     Jump       3km Run Passing
 1    Goldsbury   Shaun        16           20     40
 2      Heath    Brendan       19           16     34
 3      Peters     Mike        18           19     38
 4     Pitman       Kirk       20           18     32
 5      Turner     Phillip     17           17     36
 6
 7
 8
 9
 10
 11
 12
 13
 14
 15
 16
 17
 18
 19
 20
 21
 22
 23
 24
0   0   0   0   0
                    Total
                     76
                     69
                     75
                     70
                     70
                     0
                     0
                     0
                     0
                     0
                     0
                     0
                     0
                     0
                     0
                     0
                     0
                     0
                     0
                     0
                     0
                     0
                     0
                     0
Weighting(1,2,3)                  1                1              2
Target(High/Low)         High          Low              High
Name of Task             Jump          3km Run          Passing
Units                    cms           mins             %


Task Scores
Volleyball
03 Oct 2012

 Last Name     First Name Jump(cms) 3km Run(mins) Passing(%)
Goldsbury     Shaun           59.00         10.27     85.00
Heath         Brendan         93.00         12.13     60.00
Peters        Mike            83.00         11.05     75.00
Pitman        Kirk            96.00         11.23     50.00
Turner        Phillip         61.00         11.57     65.00




Last Tested                5/10/2003        6/21/2003    6/15/2003
Player Information Sheet

Last Name   First Name   Address   Home Phone   Phone Other   Cell Phone   Email   Notes
Goldsbury   Shaun
Heath       Brendan
Peters      Mike
Pitman      Kirk
Turner      Phillip
Points for Ranking First         20


  Cauldron Spreadsheet
  Welcome to the Cauldron spreadsheet. This has been designed as a tool to help volleyball coaches operating a cauldron system for
  their squad. The idea of the cauldron is to rank players based on their performance at various 'Tasks', designed by the coach to measure
  skill and physical abilities.

  Instructions
  (note: if you received a message box when you opened the spreadsheet asking whether you wanted to enable macros, you need to have
  clicked "Yes" or "Enable Macros" for this spreadsheet to work. If you click "No" or "Disable macros" when you opened the spreadsheet,
  you will need to close it down and re-open again, this time choosing to enable macros.)

  Step 1: Enter Player Details
  - Click on the sheet labeled "PlayerInfo".
  - Enter player names and other details into the sheet. (note, the names are the only information used in other parts of the spreadsheet.
  Feel free to add or delete other detail columns ie address, email, height, weight etc as you see fit.)


  Step 2: Creating a new 'Task'.
   - Click on the sheet labeled "TaskData". You will see that the names you have entered in the PlayerInfo sheet appear here.
   - Enter the 'Weighting' for the new Task in cell C1. The weighting is there to allow you to place more importance on some Tasks.
  Typically, most Tasks will have a weighting of 1. More important Tasks such as passing, serving or jumping may be given a weighting of
  1.5, 2 or 3 according to the value you place on them.
   - Enter the 'Target' for the new Task in cell C2. You should enter the word "High" for tasks where the athlete is trying to get a high score
  (eg press ups per minute, jump test scores, beep test scores). You should enter the word "Low" for tasks where the athlete is trying to
  get a low score (eg 3km time trials, serving errors out of 10).
   - Enter the 'Name' for the new task in cell C3. The name entered here will be appear on the final printout.
   - Enter the units that Task scores will be recorded in (ie cm for jump, time for 3 km run)
   - Beside each players name, enter the raw data score for that task. ie( 12.3 for a beep test, or 56 for a jump test). DO NOT enter the
  units in that cell (ie do not put in 56cm, just type in 56). To enter a time, use a decimal point to separate minutes from seconds, so if
  someone ran a 3 km time trial in 10 minutes and 27 seconds you would enter that as 10.27. If someone does not complete a task (ie
  through injury) then DO NOT put in 0 as their score, simply delete anything in that cell and leave it empty.

   - Once you have finished this, repeat these steps, entering the 2nd Task in column D, the 3rd Task in column E and so on. The
  spreadsheet can hold up to 11 tasks.

  Step 3: Calculating the athletes total Cauldron Score
  - Click on the sheet labeled "CauldronPoints".

								
To top