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".
Pages to are hidden for
"cauldron sheets"Please download to view full document