Spreadsheet: 160932d1339322518-help-to-automate-ranking-of-tied-teams-in-sports-scoring-program-9tmx5shts
Sheet: Sheet

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Version 3,  Issued Oct 2011
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 Team 4 sheet Round Robin
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A        B       C       D      Bye
 | Competiton |  |  |  |  |  |  |  |  |  |  |  |  | Venue/Date |  |  |  |  |  |  |  | 1 v 2   3 v 4   5 v 6   7 v 8    9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 v 4   6 v 9   1 v 7   5 v 3    2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 v 3   2 v 8   4 v 9   6 v 1    5
 | Results Chart |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 v 1   5 v 7   3 v 8   2 v 4    6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 v 5   1 v 3   6 v 2   8 v 9    7
 |  | Draw 1 |  | Draw 2 |  | Draw 3 |  | Draw 4 |  | Draw 5 |  | Draw 6 |  | Draw 7 |  | Draw 8 |  | Draw 9 |  |  |  | 3 v 6   9 v 2   7 v 4   1 v 5    8
 | Team | W/L | LSD | W/L | LSD | W/L | LSD | W/L | LSD | W/L | LSD | W/L | LSD | W/L | LSD | W/L | LSD | W/L | LSD |  |  | 2 v 7   8 v 5   9 v 3   4 v 6    1
1 | SUI | W | 76.9 | W | 73.6 | W | 185.4 | l | 182.4 | L | 185.4 | w | 15.8 | x | x | L | 27.4 | l | 185.4 |  |  | 5 v 9   7 v 6   8 v 1   3 v 2    4
2 | JPN | L | 185.4 | x | x | L | 185.4 | L | 185.4 | W | 34.5 | W | 24 | L | 113 | L | 25.8 | W | 185.4 |  |  | 6 v 8   4 v 1   2 v 5   9 v 7    3
3 | FIN | L | 94.1 | W | 184.3 | L | 162.8 | W | 22 | W | 39.7 | L | 94.4 | L | 185.4 | W | 185.4 | x | x
4 | LAT | W | 185.4 | L | 24.9 | L | 129.2 | W | 185.4 | L | 185.4 | L | 185.4 | L | 57 | x | x | w | 185.4 |  |  | 1.  Data must be entered in the white cells only as the workshheet is password
5 | DEN | L | 11.2 | L | 67.8 | x | x | W | 185.4 | W | 185.4 | l | 49.6 | W | 185.4 | w | 185.4 | L | 49 |  |  | protected to avoid accidental delection of the formulas, the password is   curler.
6 | SVK | W | 88.7 | L | 66.6 | L | 185.4 | x | x | L | 60.8 | W | 185.4 | W | 185.4 | W | 170.2 | W | 185.4 |  |  | 2.  Enter abbreviated team names in Col B, W for a win L for a loss and the LSD
7 | CZE | L | 185.4 | L | 10.2 | W | 185.4 | L | 69.4 | x | x | W | 128.6 | W | 28.1 | L | 13.7 | L | 99.8 |  |  | in the appropriate box.
8 | GER | W | 96.4 | W | 14 | W | 185.4 | L | 185.4 | L | 5.8 | x | x | L | 24.4 | W | 106 | L | 77.6 |  |  | 3.  Results will appear in the chart below and show wins, ranking and the
9 | ITA | x | x | W | 185.4 | W | 185.4 | w | 32.2 | W | 79.6 | L | 58.8 | W | 156.4 | l | 134.5 | W | 66.4 |  |  | average LSD with the least favourable distance deducted.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4.  For the final ranking of tied teams delete the "x" of the teams NOT involved in
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | cells C28 to C37, the DSC of the tied teams will also be ranked.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5.  The Green coloured area will print to A4 size.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6.  Any problems contact [NAME]:  [EMAIL]
 |  | Ranking Results Grid |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.  To avoid deleting formulas the file is protected but can be unprotected if necessary;
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LSD | Final |  |  | the password is:  curler
 |  |  |  | Team | SUI | JPN | FIN | LAT | DEN | SVK | CZE | GER | ITA |  | Wins | Rank | LSD | Rank | Rank
 |  | x | 1 | SUI |  | 1 | 0 | 0 | 1 | 1 | 1 | 0 | 0 |  | 4 | 3rd | 106.7 | 5 | 6
 |  | x | 2 | JPN | 0 |  | 0 | 0 | 1 | 1 | 0 | 0 | 1 |  | 3 | 7th | 107.6428571428571 | 6 | 9
 |  | x | 3 | FIN | 1 | 1 |  | 0 | 1 | 0 | 0 | 1 | 0 |  | 4 | 3rd | 111.8142857142857 | 7 | 3
 |  | x | 4 | LAT | 1 | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 |  | 3 | 7th | 136.1 | 9 | 8
 |  | x | 5 | DEN | 0 | 0 | 0 | 1 |  | 0 | 1 | 1 | 1 |  | 4 | 3rd | 104.8285714285714 | 4 | 5
 |  | x | 6 | SVK | 0 | 0 | 1 | 1 | 1 |  | 1 | 1 | 0 |  | 5 | 2nd | 134.6428571428572 | 8 | 2
 |  | x | 7 | CZE | 0 | 1 | 1 | 1 | 0 | 0 |  | 0 | 0 |  | 3 | 7th | 76.45714285714287 | 2 | 7
 |  | x | 8 | GER | 1 | 1 | 0 | 1 | 0 | 0 | 1 |  | 0 |  | 4 | 3rd | 72.80000000000003 | 1 | 4
 |  | x | 9 | ITA | 1 | 0 | 1 | 1 | 0 | 1 | 1 | 1 |  |  | 6 | 1st | 101.9 | 3 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAGE 1
 |  |  |  | Senior Curling Championships 2012
 | Team |  |  | Played |  |  | Won |  |  | Lost |  |  | LSD |  |  | Final Rank
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAGE 2