Spreadsheet: 159404d1338619342-help-to-automate-ranking-of-tied-teams-in-sports-scoring-program-9tmx5shts-sample-2
Sheet: Sheet

 |  | RESULTS GRID |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 Team 4 sheet Round Robin
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A         B        C         D    Bye
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 72 | 72 |  |  |  | Final |  |  |  |  | 1 v 2   3 v 4   5 v 6   7 v 8    9
 |  | Team | SUI | JPN | FIN | LAT | DEN | SVK | CZE | GER | ITA | M | PL | W | L | LSD | Rank |  |  |  |  | 8 v 4   6 v 9   1 v 7   5 v 3    2 |  |  |  |  |  |  |  |  |  | PL | W | L | Diff | R1 | R2 | T |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R | CIF | FINAL
1 | 5 | SUI |  | W | L | L | W | W | W | L | L | 8 | 8 | 4 | 4 | 66.14285714285714 | 5 |  |  |  |  | 7 v 3   2 v 8   4 v 9   6 v 1    5 |  |  |  |  |  |  |  |  | SUI | 8 | 4 | 4 | 0 | 4000 | 400 | 4400 | 0 | 0 | 0 | SUIDEN | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3.11 | 0 | 0 | 0 | 0 | 4403.11 | 5 | 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 | 8 | JPN | L |  | L | L | W | W | L | L | W | 8 | 8 | 3 | 5 | 64.25714285714285 | 8 |  |  |  |  | 4 v 5   1 v 3   6 v 2   8 v 9    7 |  |  |  |  |  |  |  |  | JPN | 8 | 3 | 5 | -2 | 2000 | 200 | 2200 | 0 | 0 | JPNLAT | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -3.1 | 0 | 0 | 0 | 0 | 0 | 2196.9 | 8 | 1 | 8
 |  | 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 | 2 | FIN | W | W |  | L | L | L | W | W | W | 8 | 8 | 5 | 3 | 86.60000000000001 | 2 |  |  |  |  | 2 v 7   8 v 5   9 v 3   4 v 6    1 |  |  |  |  |  |  |  |  | FIN | 8 | 5 | 3 | 2 | 6000 | 600 | 6600 | 0 | 0 | 0 | 0 | FINSVK | 0 | FINGER | FINITA | 0 | 0 | 0 | 0 | -3.1 | 0 | 3.11 | 0 | 6600.009999999999 | 1 | 2 | 2
 |  | 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 | 7 | LAT | W | W | W |  | L | L | L | L | L | 8 | 8 | 3 | 5 | 73.37142857142858 | 7 |  |  |  |  | 6 v 8   4 v 1   2 v 5   9 v 7    3 |  |  |  |  |  |  |  |  | LAT | 8 | 3 | 5 | -2 | 2000 | 200 | 2200 | 0 | LATJPN | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2200 | 7 | 1 | 7
 |  | LSD | 65.3 | 65.3 | 123 |  | 123 | 145.6 | 12 | 0 | 125
5 | 6 | DEN | L | L | W | W |  | L | W | L | W | 8 | 8 | 4 | 4 | 72.52857142857144 | 6 |  |  |  |  | 1.  Enter data in the white cells in Page 1 only as the workshheet is password protedted |  |  |  |  |  |  |  |  | DEN | 8 | 4 | 4 | 0 | 4000 | 400 | 4400 | DENSUI | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4400 | 6 | 1 | 6
 |  | 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 | 1 | SVK | L | L | W | W | W |  | W | W | L | 8 | 8 | 5 | 3 | 69.28571428571429 | 1 |  |  |  |  | 2.  Enter abbreviated team names in Col C of the grid and the ongoing scores "W" for |  |  |  |  |  |  |  |  | SVK | 8 | 5 | 3 | 2 | 6000 | 600 | 6600 | 0 | 0 | [NAME] | 0 | 0 | 0 | SVKGER | SVKITA | 0 | 0 | 0 | 0 | 0 | 0 | 3.11 | -3.1 | 6600.009999999999 | 1 | 1 | 1
 |  | 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 | 9 | CZE | L | W | L | W | L | L |  | L | L | 8 | 8 | 2 | 6 | 68.87142857142858 | 9 |  |  |  |  | 3.  Results will appear in Page 2 the chart below and show wins, ranking and the average |  |  |  |  |  |  |  |  | CZE | 8 | 2 | 6 | -4 | 1000 | 100 | 1100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1100 | 9 | 1 | 9
 |  | 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 | 4 | GER | W | W | L | W | W | L | W |  | L | 8 | 8 | 5 | 3 | 75.44285714285715 | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | GER | 8 | 5 | 3 | 2 | 6000 | 600 | 6600 | 0 | 0 | GERFIN | 0 | 0 | GERSVK | 0 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -3.1 | 6596.9 | 3 | 2 | 4
 |  | LSD | 185.4 | 160 | 99.7 | 45 | 67.6 | 0 | 56.7 |  | 99.1
9 | 3 | ITA | W | L | L | W | L | W | W | W |  | 8 | 8 | 5 | 3 | 48 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  | ITA | 8 | 5 | 3 | 2 | 6000 | 600 | 6600 | 0 | 0 | [NAME] | 0 | 0 | ITASVK | 0 | ITAGER | 0 | 0 | -3.1 | 0 | 0 | 0 | 0 | 0 | 6596.9 | 3 | 1 | 3
 |  | LSD | 24.7 | 105.4 | 46 | 0 | 57.6 | 185.4 | 78.4 | 23.9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Page 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GF | P | Diff | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | SUIJPN | SUI | JPN | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 4 | FINLAT | FIN | LAT | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 6 | DENSVK | DEN | SVK | L | W | 0 | -3 | -1 | -3.1
 |  |  |  | Senior Curling Championships 2012 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 8 | CZEGER | CZE | GER | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 4 | GERLAT | GER | LAT | W | L | 1 | 3 | 1 | 3.11
 | Team |  |  | Played |  |  | Won |  |  | Lost |  |  | LSD |  |  | Final Rank |  |  |  | 6 | 9 | SVKITA | SVK | ITA | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 7 | SUICZE | SUI | CZE | W | L | 1 | 3 | 1 | 3.11
1 | SVK |  |  |  | 8 |  |  | 5 |  |  | 3 |  | 69.28571428571429 |  |  | 1 |  |  |  | 5 | 3 | DENFIN | DEN | FIN | W | L | 1 | 3 | 1 | 3.11
2 | FIN |  |  |  | 8 |  |  | 5 |  |  | 3 |  | 86.60000000000001 |  |  | 2 |  |  |  | 7 | 3 | CZEFIN | CZE | FIN | L | W | 0 | -3 | -1 | -3.1
3 | ITA |  |  |  | 8 |  |  | 5 |  |  | 3 |  | 48 |  |  | 3 |  |  |  | 2 | 8 | JPNGER | JPN | GER | L | W | 0 | -3 | -1 | -3.1
4 | GER |  |  |  | 8 |  |  | 5 |  |  | 3 |  | 75.44285714285715 |  |  | 4 |  |  |  | 4 | 9 | LATITA | LAT | ITA | L | W | 0 | -3 | -1 | -3.1
5 | SUI |  |  |  | 8 |  |  | 4 |  |  | 4 |  | 66.14285714285714 |  |  | 5 |  |  |  | 6 | 1 | SVKSUI | SVK | SUI | L | W | 0 | -3 | -1 | -3.1
6 | DEN |  |  |  | 8 |  |  | 4 |  |  | 4 |  | 72.52857142857144 |  |  | 6 |  |  |  | 9 | 1 | ITASUI | ITA | SUI | W | L | 1 | 3 | 1 | 3.11
7 | LAT |  |  |  | 8 |  |  | 3 |  |  | 5 |  | 73.37142857142858 |  |  | 7 |  |  |  | 5 | 7 | DENCZE | DEN | CZE | W | L | 1 | 3 | 1 | 3.11
8 | JPN |  |  |  | 8 |  |  | 3 |  |  | 5 |  | 64.25714285714285 |  |  | 8 |  |  |  | 3 | 8 | FINGER | FIN | GER | W | L | 1 | 3 | 1 | 3.11
9 | CZE |  |  |  | 8 |  |  | 2 |  |  | 6 |  | 68.87142857142858 |  |  | 9 |  |  |  | 2 | 4 | JPNLAT | JPN | LAT | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PAGE 2 |  | 4 | 5 | LATDEN | LAT | DEN | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 3 | SUIFIN | SUI | FIN | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 2 | [NAME] | SVK | JPN | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 9 | [NAME] | GER | ITA | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 6 | FINSVK | FIN | SVK | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 2 | ITAJPN | ITA | JPN | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 4 | CZELAT | CZE | LAT | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 5 | SUIDEN | SUI | DEN | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 7 | JPNCZE | JPN | CZE | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 5 | GERDEN | GER | DEN | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 3 | [NAME] | ITA | FIN | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 6 | LATSVK | LAT | SVK | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 9 | DENITA | DEN | ITA | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 6 | CZESVK | CZE | SVK | L | W | 0 | -3 | -1 | -3.1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 1 | GERSUI | GER | SUI | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2 | FINJPN | FIN | JPN | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 8 | SVKGER | SVK | GER | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1 | LATSUI | LAT | SUI | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 5 | [NAME] | JPN | DEN | W | L | 1 | 3 | 1 | 3.11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 7 | ITACZE | ITA | CZE | W | L | 1 | 3 | 1 | 3.11