Spreadsheet: 159016d1338477437-help-to-automate-ranking-of-tied-teams-in-sports-scoring-program-9tmx5shts-sample-1
Sheet: Sheet

 |  | RESULTS GRID |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 Team 4 sheet Round Robin
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Manual |  |  |  | A         B        C         D    Bye
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  |  |  |  |  | Final | Final |  |  |  | 1 v 2   3 v 4   5 v 6   7 v 8    9
 |  | Team | SUI | JPN | FIN | LAT | DEN | SVK | CZE | GER | ITA |  | PL | W | L | LSD | Rank | Ranking |  |  |  | 8 v 4   6 v 9   1 v 7   5 v 3    2
 | 1 | SUI |  | W | L | L | W | W | W | L | L |  | 8 | 4 | 4 | 66.14285714285714 |  | 4th |  |  |  | 7 v 3   2 v 8   4 v 9   6 v 1    5
 |  | LSD |  | 165.4 | 46.6 | 23.4 | 120 | 49.2 | 33 | 125.1 | 65.7 |  |  |  |  |  |  |  |  |  |  | 9 v 1   5 v 7   3 v 8   2 v 4    6
 | 2 | JPN | L |  | L | L | W | W | L | L | W |  | 8 | 3 | 5 | 64.25714285714285 |  | 9th |  |  |  | 4 v 5   1 v 3   6 v 2   8 v 9    7
 |  | LSD | 65.4 |  | 122 | 12.4 | 123 | 67.7 | 185.4 | 12.3 | 47 |  |  |  |  |  |  |  |  |  |  | 3 v 6   9 v 2   7 v 4   1 v 5    8
 | 3 | FIN | W | W |  | L | L | L | W | W | W |  | 8 | 5 | 3 | 86.60000000000001 |  | 3rd |  |  |  | 2 v 7   8 v 5   9 v 3   4 v 6    1
 |  | LSD | 65.3 | 123 |  | 185.4 | 123 | 123.5 | 12.5 | 145 | 13.9 |  |  |  |  |  |  |  |  |  |  | 5 v 9   7 v 6   8 v 1   3 v 2    4
 | 4 | LAT | W | W | W |  | L | L | L | L | L |  | 8 | 3 | 5 | 73.37142857142858 |  | 8th |  |  |  | 6 v 8   4 v 1   2 v 5   9 v 7    3
 |  | LSD | 65.3 | 65.3 | 123 |  | 123 | 145.6 | 12 | 0 | 125
 | 5 | DEN | L | L | W | W |  | L | W | L | W |  | 8 | 4 | 4 | 72.52857142857144 |  | 5th |  |  |  | 1.  Enter data in the white cells in Page 1 only as the workshheet is password protedted
 |  | LSD | 65.3 | 65.3 | 12 | 122 |  | 185.4 | 185.4 | 12 | 45.7 |  |  |  |  |  |  |  |  |  |  | to avoid accidental delection of the formulas. The password is   curler.
 | 6 | SVK | L | L | W | W | W |  | W | W | L |  | 8 | 5 | 3 | 69.28571428571429 |  | 2nd |  |  |  | 2.  Enter abbreviated team names in Col C of the grid and the ongoing scores "W" for
 |  | LSD | 176.6 | 12 | 67.4 | 23 | 136.7 |  | 123 | 99.4 | 23.5 |  |  |  |  |  |  |  |  |  |  | a win "L" for a loss and the LSD in the appropriate box.
 | 7 | CZE | L | W | L | W | W | L |  | L | L |  | 8 | 3 | 5 | 68.87142857142858 |  | 7th |  |  |  | 3.  Results will appear in Page 2 the chart below and show wins, ranking and the average
 |  | LSD | 123 | 45.6 | 98 | 45.7 | 120 | 23.9 |  | 48.5 | 100.4 |  |  |  |  |  |  |  |  |  |  | LSD with the least favourable distance deducted and will be printed A4 size.
 | 8 | GER | W | W | L | W | L | L | W |  | L |  | 8 | 4 | 4 | 75.44285714285715 |  | 6th
 |  | LSD | 185.4 | 160 | 99.7 | 45 | 67.6 | 0 | 56.7 |  | 99.1
 | 9 | ITA | W | L | L | W | L | W | W | W |  |  | 8 | 5 | 3 | 48 |  | 1st
 |  | LSD | 24.7 | 105.4 | 46 | 0 | 57.6 | 185.4 | 78.4 | 23.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page 1
 |  |  |  | Senior Curling Championships 2012
 | Team |  |  | Played |  |  | Won |  |  | Lost |  |  | LSD |  |  | Final Rank
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAGE 2